Query 4-5 times slower after ANALYZE

Поиск
Список
Период
Сортировка
От Philippe Lang
Тема Query 4-5 times slower after ANALYZE
Дата
Msg-id E6A0649F1FBFA3408A37F505400E7AC215CDA9@email.attiksystem.ch
обсуждение исходный текст
Ответы Re: Query 4-5 times slower after ANALYZE  (Bill Moran <wmoran@potentialtech.com>)
Re: Query 4-5 times slower after ANALYZE  (Sebastian Pawłowski <sebpaa@gmail.com>)
Список pgsql-general
Hi,

I'm using Postgresql 8.3.6 under Freebsd 7.1.

After a fresh restore of a customer dump (running version 8.2.7 at the
moment), a rather big query executes in about 30 seconds. As soon as I
run ANALYZE, it is instantly 4-5 times slower. I could check that
multiples times.

Here is the EXPLAIN ANALYZE before the ANALYZE:
http://www.attiksystem.ch/postgresql/query_slower_after_analyze/before.t
xt

And here the the EXPLAIN ANALYZE after the ANALYZE:
http://www.attiksystem.ch/postgresql/query_slower_after_analyze/after.tx
t

Any idea what could be turned on/off in order not to have this slowdown
after the ANALYZE?

Best regards,

---------------
Philippe Lang
Attik Syste,

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

Предыдущее
От: Simon Riggs
Дата:
Сообщение: Re: PostgreSql with or without Plus?
Следующее
От: Ivan Sergio Borgonovo
Дата:
Сообщение: Re: Is PGSQL enough safe for internet?