X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id 828A2D1D29F for ; Wed, 10 Mar 2004 07:36:45 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 82946-07 for ; Wed, 10 Mar 2004 03:36:41 -0400 (AST) Received: from email.philnet (unknown [61.1.74.109]) by svr1.postgresql.org (Postfix) with ESMTP id 6335AD1B979 for ; Wed, 10 Mar 2004 03:36:32 -0400 (AST) Received: from phil.com.sg (IDENT:1qSnEZZXYhQQf67EVn/nl/6FhtUsPH8M@xserver.philnet [172.16.1.6]) by email.philnet (8.11.6/8.11.2) with ESMTP id i2A7JrB11893 for ; Wed, 10 Mar 2004 12:49:53 +0530 Message-ID: <404EBDA5.ED3248AE@phil.com.sg> Date: Wed, 10 Mar 2004 12:33:01 +0530 From: Maneesha Nunes X-Mailer: Mozilla 4.78 [en] (X11; U; Linux 2.4.20-8 i686) X-Accept-Language: en MIME-Version: 1.0 To: pgsql-performance@postgresql.org Subject: Drop Tables Very Slow in Postgresql 7.2.1 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-MailScanner: Found to be clean X-Virus-Scanned: by amavisd-new at postgresql.org X-Spam-Status: No, hits=1.4 tagged_above=0.0 required=5.0 tests=BAYES_20, RCVD_IN_DYNABLOCK, RCVD_IN_RFCI, RCVD_IN_SORBS X-Spam-Level: * X-Archive-Number: 200403/179 X-Sequence-Number: 6035 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.