| From: | "Philippe Lang" <philippe(dot)lang(at)attiksystem(dot)ch> |
|---|---|
| To: | <pgsql-general(at)postgresql(dot)org> |
| Subject: | Query 4-5 times slower after ANALYZE |
| Date: | 2009-03-18 09:55:42 |
| Message-ID: | E6A0649F1FBFA3408A37F505400E7AC215CDA9@email.attiksystem.ch |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | 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,
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Ivan Sergio Borgonovo | 2009-03-18 10:19:02 | Re: Is PGSQL enough safe for internet? |
| Previous Message | Simon Riggs | 2009-03-18 09:53:40 | Re: PostgreSql with or without Plus? |