Received: from localhost (maia-4.hub.org [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 2B2A59FC16A for ; Fri, 8 Jun 2007 05:22:26 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 30689-01 for ; Fri, 8 Jun 2007 05:22:18 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 Received: from floppy.pyrenet.fr (news.pyrenet.fr [194.116.145.2]) by postgresql.org (Postfix) with ESMTP id 7413E9FBFFD for ; Fri, 8 Jun 2007 05:22:19 -0300 (ADT) Received: by floppy.pyrenet.fr (Postfix, from userid 106) id 6AA4A30948; Fri, 8 Jun 2007 10:22:15 +0200 (MET DST) From: choksi X-Newsgroups: pgsql.performance Subject: Database size Date: Fri, 08 Jun 2007 01:22:14 -0700 Organization: http://groups.google.com Lines: 10 Message-ID: <1181290934.160823.161630@w5g2000hsg.googlegroups.com> Mime-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" X-Complaints-To: groups-abuse@google.com User-Agent: G2/1.0 X-HTTP-UserAgent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-GB; rv:1.8.1.4) Gecko/20070515 Firefox/2.0.0.4,gzip(gfe),gzip(gfe) Complaints-To: groups-abuse@google.com Injection-Info: w5g2000hsg.googlegroups.com; posting-host=213.170.154.89; posting-account=1rWf5w0AAACtr3Mtm-5B6XVgm9oDnKM2 To: pgsql-performance@postgresql.org X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.001 tagged_above=0 required=5 tests=BAYES_50=0.001 X-Spam-Level: X-Archive-Number: 200706/269 X-Sequence-Number: 25302 Hi all, I had a database which uses to hold some 50 Mill records and disk space used was 103 GB. I deleted around 34 Mill records but still the disk size is same. Can some on please shed some light on this. Thank in advance for all the help. Dhawal Choksi