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


---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster

Reply via email to