Re: Poor delete performance AFTER vacuum analyze - Mailing list pgsql-performance

From Tom Lane
Subject Re: Poor delete performance AFTER vacuum analyze
Date
Msg-id 27641.1058764142@sss.pgh.pa.us
Whole thread Raw
In response to Re: Poor delete performance AFTER vacuum analyze  ("Jeremy M. Guthrie" <jeremy.guthrie@berbee.com>)
List pgsql-performance
"Jeremy M. Guthrie" <jeremy.guthrie@berbee.com> writes:
> I looked back at my code and I also need to reclarify something.  The delete
> at the end is multiple delete statements within a transaction.

I think you are going to have to show us all the details of what you're
doing in between these queries.  I was expecting to see a difference in
query plans, but you've got the exact same plan in all three runs ---
so it's not the planner making the difference here, nor the ANALYZE
statistics.  My best conjecture now is something odd about the way you
are deleting the old data or loading the new.

            regards, tom lane

pgsql-performance by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: [pgsql-advocacy] About the default performance
Next
From: SZUCS Gábor
Date:
Subject: Re: Dual Xeon + HW RAID question