Re: seqscan for 100 out of 3M rows, index present

Поиск
Список
Период
Сортировка
От Willy-Bas Loos
Тема Re: seqscan for 100 out of 3M rows, index present
Дата
Msg-id CAHnozTijV0A64pcM+NtU+ZpPjwtADroiJ9kzZ5CEX6ZRqNoraw@mail.gmail.com
обсуждение исходный текст
Ответ на Re: seqscan for 100 out of 3M rows, index present  (Igor Neyman <ineyman@perceptron.com>)
Список 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 по дате отправления:

Предыдущее
От: Igor Neyman
Дата:
Сообщение: Re: seqscan for 100 out of 3M rows, index present
Следующее
От: Jeff Janes
Дата:
Сообщение: Re: seqscan for 100 out of 3M rows, index present