"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