Re: Order by (for 15 rows) adds 30 seconds to query time

Поиск
Список
Период
Сортировка
От Kevin Grittner
Тема Re: Order by (for 15 rows) adds 30 seconds to query time
Дата
Msg-id 4B168F87020000250002CF9F@gw.wicourts.gov
обсуждение исходный текст
Ответ на Re: Order by (for 15 rows) adds 30 seconds to query time  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: Order by (for 15 rows) adds 30 seconds to query time  (Richard Neill <rn214@cam.ac.uk>)
Список pgsql-performance
Дерево обсуждения 
Tom Lane <tgl@sss.pgh.pa.us> wrote:

> That does look weird.  Do we have a self-contained test case?

Richard, could you capture the schema for the affected tables and
views with pg_dump -s and also the related rows from pg_statistic?
(The actual table contents aren't needed to see this issue.)

-Kevin

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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Order by (for 15 rows) adds 30 seconds to query time
Следующее
От: Richard Neill
Дата:
Сообщение: Re: Order by (for 15 rows) adds 30 seconds to query time