Re: seqscan strikes again

Поиск
Список
Период
Сортировка
Искать
От
Gaetano Mendola
Тема
Re: seqscan strikes again
Дата
Msg-id
41931BA3.5010008@bigfoot.com
Ответ на
seqscan strikes again (Jim C. Nasby)
Список
Дерево обсуждения
seqscan strikes again "Jim C. Nasby" <decibel@decibel.org>
Re: seqscan strikes again "Joshua D. Drake" <jd@commandprompt.com>
Re: seqscan strikes again "Jim C. Nasby" <decibel@decibel.org>
Re: seqscan strikes again Gaetano Mendola <mendola@bigfoot.com>
Re: seqscan strikes again Tom Lane <tgl@sss.pgh.pa.us>
Jim C. Nasby wrote:
 > I'm wondering if there's any way I can tweak things so that the estimate
 > for the query is more accurate (I have run analyze):

Can you post your configuration file ? I'd like to see for example your
settings about: random_page_cost and effective_cache_size.




Regards
Gaetano Mendola
В списке pgsql-performance по дате отправления
От: Edwin Eyan Moragas
Дата:
От: Steinar H. Gunderson
Дата:
FAQ