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 vacuumed/ reindexed on a daily basis.
We have recreated the same database on a Linux Redhat release 9 OS, and used PostgreSQL 7.3.2, the drop here is really fast. Any suggestions as to how I could improve the performance of drop on postgresql7.2.1. Thanks maneesha. ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster