Re: 7.0.2 -> 7.1 performance drop

--- Frank Bax <fbax@sympatico.ca> wrote:
> The script just deletes all rows in
> tables, imports
> data as seperate inserts for each row, then does vaccum
> analyse on the
> tables.  I've read that delete/rebuild of indexes will likely
> improve
> performance of this script, but the runtime itself is not
> really a concern
> here, just the change in runtime between releases.  I'm
> curious what
> changed between releases to cause the slower processing?

Your script performs 3 separate actions.  Do you know which one
(delete, import, vacuum analyze) is slower when using the new
version of PG?  That will help pinpoint the problem so that we
can more easily solve the problem.

Brent

Brent

__________________________________________________
Do You Yahoo!?
Find a job, post your resume.
http://careers.yahoo.com