Re: Postgres 8.3, four times slower queries?

Поиск
Список
Период
Сортировка
От Aaron Guyon
Тема Re: Postgres 8.3, four times slower queries?
Дата
Msg-id f0afbb9b0903030952k5bd08302o2cd71cd195f2ea79@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Postgres 8.3, four times slower queries?  (david@lang.hm)
Список pgsql-performance
Дерево обсуждения
On Tue, Mar 3, 2009 at 12:38 PM, <david@lang.hm> wrote:
if you haven't done a vaccum analyse on either installation then postgres' idea of what sort of data is in the database is unpredictable, and as a result it's not surprising that the two systems guess differently about what sort of plan is going to be most efficiant.

try doing vaccum analyse on both databases and see what the results are.

David Lang

These are the results with vacuum analyze:
8.2.12: 624.366 ms
8.3.3: 1273.601 ms
Вложения

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

Предыдущее
От: Robert Haas
Дата:
Сообщение: Re: Problems with ordering (can't force query planner to use an index)
Следующее
От: Sebastjan Trepca
Дата:
Сообщение: Re: Problems with ordering (can't force query planner to use an index)