Re: Postgres 7.3.2 -> 8.1.2 upgrade performance issue

David Brain <dbrain@bandwidth.com> 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 (obviously I couldn't just drop in the old
> config).

> Any thoughts as to where to look, or what to do to fix this?

Did you remember to VACUUM ANALYZE after loading the data?  It sounds
to me like bad choices of plans ...

            regards, tom lane