pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
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.





view thread (2+ messages)  latest in thread

Message-ID: <404EBDA5.ED3248AE@phil.com.sg>
Permalink:  ../404EBDA5.ED3248AE@phil.com.sg/
Also on:    postgresql.org/message-id/404EBDA5.ED3248AE@phil.com.sg

 · 

reply

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