Re: query performance, though it was timestamps,maybe just table size?

Поиск
Список
Период
Сортировка
От Henry Drexler
Тема Re: query performance, though it was timestamps,maybe just table size?
Дата
Msg-id CAAtgU9S0h2LKk=+cs_+hv2GjqBDTfKyj5QOcTwE2c3kAG=1QWw@mail.gmail.com
обсуждение исходный текст
Ответ на Re: query performance, though it was timestamps,maybe just table size?  ("Kevin Grittner" <kgrittn@mail.com>)
Список pgsql-general
Дерево обсуждения
On Fri, Nov 30, 2012 at 1:23 PM, Kevin Grittner <kgrittn@mail.com> wrote:
Henry Drexler wrote:

> why would the query time go from 4 minutes to over 50, for an
> increase in table rows from 30 million to 65 million?

Did the active (frequently referenced) portion of the database go
from something which fit in cache to something which didn't? Did
any hash table or sort nodes in plans go from fitting in work_mem
to spilling to disk? Did any indexes need an extra level in the
tree? Did any plans change based on size to something which is less
than optimal, suggesting a need to tune the cost factors?

-Kevin

Thank you for the list - I will research those in the manual.

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

Предыдущее
От: Henry Drexler
Дата:
Сообщение: Re: query performance, though it was timestamps,maybe just table size?
Следующее
От: John R Pierce
Дата:
Сообщение: Re: difference in query performance due to the inclusion of a polygon geometry field