Did you analyze after you imported the dump? Woody -----Original Message----- From: pgsql-general-owner@xxxxxxxxxxxxxx [mailto:pgsql-general-owner@xxxxxxxxxxxxxx] On Behalf Of David Brain Sent: Friday, February 03, 2006 10:03 AM To: pgsql-general@xxxxxxxxxxxxxx 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
