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 91BC4D1C952 for ; Sun, 14 Mar 2004 15:52:26 +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 97501-05 for ; Sun, 14 Mar 2004 11:52:29 -0400 (AST) Received: from fep04-mail.bloor.is.net.cable.rogers.com (fep04-mail.bloor.is.net.cable.rogers.com [66.185.86.74]) by svr1.postgresql.org (Postfix) with ESMTP id 14AD7D1BACC for ; Sun, 14 Mar 2004 11:52:24 -0400 (AST) Received: from phlogiston.dydns.org ([65.49.121.67]) by fep04-mail.bloor.is.net.cable.rogers.com (InterMail vM.5.01.05.12 201-253-122-126-112-20020820) with ESMTP id <20040314155154.ICB3598.fep04-mail.bloor.is.net.cable.rogers.com@phlogiston.dydns.org> for ; Sun, 14 Mar 2004 10:51:54 -0500 Received: by phlogiston.dydns.org (Postfix, from userid 1000) id 7C2B23E38; Sun, 14 Mar 2004 10:52:27 -0500 (EST) Date: Sun, 14 Mar 2004 10:52:27 -0500 From: Andrew Sullivan To: pgsql-performance@postgresql.org Subject: Re: Drop Tables Very Slow in Postgresql 7.2.1 Message-ID: <20040314155227.GA1400@phlogiston.dyndns.org> Mail-Followup-To: pgsql-performance@postgresql.org References: <404EBDA5.ED3248AE@phil.com.sg> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <404EBDA5.ED3248AE@phil.com.sg> User-Agent: Mutt/1.5.5.1+cvs20040105i X-Authentication-Info: Submitted using SMTP AUTH LOGIN at fep04-mail.bloor.is.net.cable.rogers.com from [65.49.121.67] using ID at Sun, 14 Mar 2004 10:51:54 -0500 X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200403/184 X-Sequence-Number: 6040 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