Postgres Pro
Downloads
Home   >   mailing lists

Re: sudden drop in delete performance - Mailing list pgsql-general

From Tom Lane
Subject Re: sudden drop in delete performance
Date
Msg-id 19823.1164815525@sss.pgh.pa.us
Whole thread Raw
In response to sudden drop in delete performance  ("surabhi.ahuja" <surabhi.ahuja@iiitb.ac.in>)
List pgsql-general
Tree view 
"surabhi.ahuja" <surabhi.ahuja@iiitb.ac.in> writes:
> I was using Postgres 8.0.0
> I have upgraded it to Postgres 8.1.5
> I have seen that the delete performance has degraded considerably.

Did you remember to re-ANALYZE your tables after transferring your database?
If so, what does EXPLAIN ANALYZE show for the slow delete?

            regards, tom lane

pgsql-general by date:

Previous
From: Michal Taborsky - Internet Mall
Date:
Subject: LOCK ... NOWAIT throws error
Next
From: "Joshua D. Drake"
Date:
Subject: Re: Only MONO/WinForms is a way to go