"surabhi.ahuja" <[EMAIL PROTECTED]> 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
---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
