Re: [PERFORM] Drop Tables Very Slow in Postgresql 7.2.1

2004-03-14 Thread Andrew Sullivan
On Wed, Mar 10, 2004 at 12:33:01PM +0530, Maneesha Nunes wrote: > Hello there !!! > > I am using postgresql7.2.1 as the backend for an E.R.P system running > on Linux Redhat 7.2(Enigma) You should upgrade, to at the _very least_ the last release of 7.2. There were bugs in earlier releases fi

[PERFORM] Drop Tables Very Slow in Postgresql 7.2.1

2004-03-13 Thread Maneesha Nunes
Hello there !!! I am using postgresql7.2.1 as the backend for an E.R.P system running on Linux Redhat 7.2(Enigma) The database size is around 20-25GB Dropping of an individual table whose size is around 200Mb takes more than 7 mins, and also increases the load on our System The database is vac