Did you analyze after you imported the dump?
Woody
-----Original Message-----
From: pgsql-general-owner@postgresql.org
[mailto:pgsql-general-owner@postgresql.org] On Behalf Of David Brain
Sent: Friday, February 03, 2006 10:03 AM
To: pgsql-general@postgresql.org
Subject: [GENERAL] Postgres 7.3.2 -> 8.1.2 upgrade performance issue
Hi,
Recently tried an upgrade from 7.3.2 to 8.1.2. The actual upgrade went
pretty well. However my application is now getting >10 times slower INSERT
times than it was under 7.3.2. As far as possible I mirrored the settings
in postgresql.conf (obviously I couldn't just drop in the old config).
Any thoughts as to where to look, or what to do to fix this?
Thanks,
David.
---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq