Did you 'vacuum analyze' after you did the update? Make sure you have the correct indexes in place on your foreign keys.
Did you have fsync off on your previous installation? Give some more details and I'm sure people will be able to give better advice than me. Regards, Ben ""surabhi.ahuja"" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] 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. Nothing else has changed. Please help thanks regards Surabhi
