On Wed, Jun 26, 2013 at 9:30 PM, Igor Neyman <ineyman@xxxxxxxxxxxxxx> 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
