Re: seqscan for 100 out of 3M rows, index present - Mailing list pgsql-performance

From Willy-Bas Loos
Subject Re: seqscan for 100 out of 3M rows, index present
Date
Msg-id CAHnozTijV0A64pcM+NtU+ZpPjwtADroiJ9kzZ5CEX6ZRqNoraw@mail.gmail.com
Whole thread Raw
In response to Re: seqscan for 100 out of 3M rows, index present  (Igor Neyman <ineyman@perceptron.com>)
List pgsql-performance


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

pgsql-performance by date:

Previous
From: Igor Neyman
Date:
Subject: Re: seqscan for 100 out of 3M rows, index present
Next
From: Jeff Janes
Date:
Subject: Re: seqscan for 100 out of 3M rows, index present