OK - spent some more time profiling what was going on on both the client
and server machine. It began ti look more like a connector problem (I
was seeing low CPU usage on both client & server and could see very slow
BIND/INSERT/COMMIT commands being sent to the db).
Upgraded to Npgsql 1.0beta
Tom Lane wrote:
Did you remember to VACUUM ANALYZE after loading the data? It sounds
to me like bad choices of plans ...
Yes - although I have autovacuum off, partly to make an apples to apples
comparison with 7.3 and partly due to the nature of the app.
On the application side I'm con
Did you analyze after you imported the dump?
Woody
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] 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 performa
David Brain <[EMAIL PROTECTED]> writes:
> 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 (obvio
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
conf
