Re: Query with limit goes from few ms to hours

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Query with limit goes from few ms to hours
Дата
Msg-id 26280.1350231332@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Query with limit goes from few ms to hours  (henk de wit <henk53602@hotmail.com>)
Ответы Re: Query with limit goes from few ms to hours  (henk de wit <henk53602@hotmail.com>)
Список pgsql-performance
henk de wit <henk53602@hotmail.com> writes:
> For some reason the mailinglist software seems to block the email as soon as the planner details are in it, so I
pastedthose on pastebin.com: http://pastebin.com/T5JTwh5T 

You need a less horrid estimate for the join size.  Possibly an ANALYZE
on the parent table (stream_store) would help.

            regards, tom lane


В списке pgsql-performance по дате отправления:

Предыдущее
От: Stefan Keller
Дата:
Сообщение: Re: Index over all partitions (aka global index)?
Следующее
От: John Nash
Дата:
Сообщение: WebSphere Application Server support for postgres