Re: 7.0.2 -> 7.1 performance drop - Mailing list pgsql-general

From Brent R. Matzelle
Subject Re: 7.0.2 -> 7.1 performance drop
Date
Msg-id 20011112184843.21237.qmail@web13006.mail.yahoo.com
Whole thread Raw
In response to 7.0.2 -> 7.1 performance drop  (Frank Bax <fbax@sympatico.ca>)
Responses Re: 7.0.2 -> 7.1 performance drop  (Frank Bax <fbax@sympatico.ca>)
List pgsql-general
--- 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

pgsql-general by date:

Previous
From: Frank Bax
Date:
Subject: 7.0.2 -> 7.1 performance drop
Next
From: Keary Suska
Date:
Subject: Is data storage secure?