Postgres Pro
Downloads
Home   >   mailing lists

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

From Ben Trewern
Subject Re: sudden drop in delete performance
Date
Msg-id ekk2qk$121p$1@news.hub.org
Whole thread Raw
In response to sudden drop in delete performance  ("surabhi.ahuja" <surabhi.ahuja@iiitb.ac.in>)
List pgsql-general
Tree view
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
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

pgsql-general by date:

Previous
From: Dave Bodenstab
Date:
Subject: Create index on array element?
Next
From: "hubert depesz lubaczewski"
Date:
Subject: Re: postgresql 8.2 rc1 - crash