Postgres 7.3.2 -> 8.1.2 upgrade performance issue

From: David Brain <dbrain(at)bandwidth(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Postgres 7.3.2 -> 8.1.2 upgrade performance issue
Date: 2006-02-03 15:02:37
Message-ID: 43E3708D.7010702@bandwidth.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2006-02-03 15:35:47 Re: error calling pgmail function
Previous Message Stéphane SCHILDKNECHT 2006-02-03 14:43:01 Number format problem