On Wed, Jun 26, 2013 at 9:30 PM, Igor Neyman <iney...@perceptron.com> wrote:
> > How much RAM you have on this machine? > 16 GB > What else is this machine is being used for (besides being db server)? > It's my laptop by now, but i was working on a server before that. The laptop gives me some liberties to play around. I could reproduce it well on my laptop, so i thought it would do. > And, what is your setting for effective_cache_size? It looks like you > didn't change it from default (128MB). > You need to adjust effective_cache_size so somewhat between 60%-75% of > RAM, if the database is the main process running on this machine. > correct, it was 128GB, changed it to 12GB, to no avail. > > > -- "Quality comes from focus and clarity of purpose" -- Mark Shuttleworth
