From: Maneesha Nunes <mnunes@phildigital.com>
To: pgsql-performance@postgresql.org
Subject: Drop Tables Very Slow in Postgresql 7.2.1
Date: Wed, 10 Mar 2004 12:33:01 +0530
Message-ID: <404EBDA5.ED3248AE@phil.com.sg> (raw)
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.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: mnunes@phildigital.com
Subject: Re: Drop Tables Very Slow in Postgresql 7.2.1
In-Reply-To: <404EBDA5.ED3248AE@phil.com.sg>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox