Received: from localhost (unknown [200.46.204.183]) by developer.postgresql.org (Postfix) with ESMTP id 4A3C72E004D for ; Wed, 11 Jun 2008 05:19:50 -0300 (ADT) Received: from developer.postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 47371-03 for ; Wed, 11 Jun 2008 05:19:41 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6 Received: from yw-out-2324.google.com (yw-out-2324.google.com [74.125.46.31]) by developer.postgresql.org (Postfix) with ESMTP id 4DD8B2E0042 for ; Wed, 11 Jun 2008 05:19:44 -0300 (ADT) Received: by yw-out-2324.google.com with SMTP id 3so1692322ywj.73 for ; Wed, 11 Jun 2008 01:19:43 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:received:received:message-id:date:from:to :subject:cc:in-reply-to:mime-version:content-type :content-transfer-encoding:content-disposition:references; bh=8hjOfWltZm9xyMopix53D6e+2UIofj0uS9VBGsaOcQo=; b=FY6oGDZUUTnD61fRB82L4zUF2/apaWIN95Jk8qWfYIEulFmN7kYLBEz/tzDQBm7xva 0IZcwhKZvIRfZknsmi7Kg60aOsFFbE/hod7oFI5VPWcc6tdnRM9C1rNiX2DeV8h3zjbC mdfv4dgMOxb5X2cXcqJ6ppA5bFn5jai0gqalk= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=message-id:date:from:to:subject:cc:in-reply-to:mime-version :content-type:content-transfer-encoding:content-disposition :references; b=X/vbIAMhDRnWR5J0cRZCouh67kyTg85KidgnC32uIaIAp3lwhTymWSOv+MWCy9/4I5 4vaCMxjzkIwoTO0i6tKV+DERo4g6hEhvIbj2YC3NF0ITx83PHovZzgiUdxYz3XQfvwb2 9GNdmaNHGpj4YmiP2w7Oi4wkK0FO+E/A+8Wso= Received: by 10.151.103.11 with SMTP id f11mr10109866ybm.174.1213172383335; Wed, 11 Jun 2008 01:19:43 -0700 (PDT) Received: by 10.151.84.7 with HTTP; Wed, 11 Jun 2008 01:19:43 -0700 (PDT) Message-ID: <2e78013d0806110119w16f50069k8f6f5d52c8f0c460@mail.gmail.com> Date: Wed, 11 Jun 2008 13:49:43 +0530 From: "Pavan Deolasee" To: "Devendra Singh Rawat" Subject: Re: Disk Space issue Cc: "Praveen Kumar (TUV)" , "tgl@sss.pgh.pa.us" , "Joshua D. Drake" , "pgsql-admin@postgresql.org" In-Reply-To: <4242E42288B6E842A52B88D4B3A3E620E069CA69@AUSMELMBX01.ad.infosys.com> MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline References: <84D57263D486374587DA0820E60A2CC601E72AFF@srit_mail.renaissance-it.com> <4242E42288B6E842A52B88D4B3A3E620E069CA69@AUSMELMBX01.ad.infosys.com> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200806/95 X-Sequence-Number: 29433 On Wed, Jun 11, 2008 at 1:12 PM, Devendra Singh Rawat wrote: > Hi All, > > I recreated my database this morning with a dump size of 3GB, which after database creation occupied 3.5GB on disk. > And in less than 8 hours it has bloated to additional 3.7GB (the disk size now is 7.2GB). > Check if you have autovacuum enabled and configured properly. Btw, you should seriously consider upgrading to newer release like 8.3 which significantly improves performance for high UPDATE work load. Thanks, Pavan -- Pavan Deolasee EnterpriseDB http://www.enterprisedb.com