Re: Postgres 7.3.2 -> 8.1.2 upgrade performance issue

Did you analyze after you imported the dump?

Woody

-----Original Message-----
From: pgsql-general-owner(at)postgresql(dot)org
[mailto:pgsql-general-owner(at)postgresql(dot)org] On Behalf Of David Brain
Sent: Friday, February 03, 2006 10:03 AM
To: pgsql-general(at)postgresql(dot)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