pg.ddx.io pgsql-performance@postgresql.org mailing list archive
help / color / mirror / Atom feedDrop Tables Very Slow in Postgresql 7.2.1
2+ messages / 2 participants
[nested] [flat]
* Drop Tables Very Slow in Postgresql 7.2.1
@ 2004-03-10 07:03 Maneesha Nunes <mnunes@phildigital.com>
2004-03-14 15:52 ` Re: Drop Tables Very Slow in Postgresql 7.2.1 Andrew Sullivan <ajs@crankycanuck.ca>
0 siblings, 1 reply; 2+ messages in thread
From: Maneesha Nunes @ 2004-03-10 07:03 UTC (permalink / raw)
To: pgsql-performance
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.
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: Drop Tables Very Slow in Postgresql 7.2.1
2004-03-10 07:03 Drop Tables Very Slow in Postgresql 7.2.1 Maneesha Nunes <mnunes@phildigital.com>
@ 2004-03-14 15:52 ` Andrew Sullivan <ajs@crankycanuck.ca>
0 siblings, 0 replies; 2+ messages in thread
From: Andrew Sullivan @ 2004-03-14 15:52 UTC (permalink / raw)
To: pgsql-performance
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 fixed in later releases; that's
why there's a 7.2.4. (I'll also point out that the 7.2 series is
missing plenty of performance enhancements which came later. I'd get
to work on upgrading, because 7.2 is now basically unmaintained.)
But in any case, you likely have issues on your system tables. I'd
do a VACUUM FULL and a complete REINDEX of the system tables next.
A
--
Andrew Sullivan | ajs@crankycanuck.ca
I remember when computers were frustrating because they *did* exactly what
you told them to. That actually seems sort of quaint now.
--J.D. Baldwin
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2004-03-14 15:52 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2004-03-10 07:03 Drop Tables Very Slow in Postgresql 7.2.1 Maneesha Nunes <mnunes@phildigital.com>
2004-03-14 15:52 ` Andrew Sullivan <ajs@crankycanuck.ca>
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