Received: from localhost (maia-2.hub.org [200.46.204.187]) by postgresql.org (Postfix) with ESMTP id 271599FA2D0 for ; Thu, 26 Jul 2007 22:03:51 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.187]) (amavisd-maia, port 10024) with ESMTP id 45921-07 for ; Thu, 26 Jul 2007 22:03:35 -0300 (ADT) X-Greylist: delayed 00:15:01.269007 by SQLgrey-1.7.5 Received: from smtp5.clear.net.nz (smtp5.clear.net.nz [203.97.33.68]) by postgresql.org (Postfix) with ESMTP id D3E449F9F05 for ; Thu, 26 Jul 2007 22:03:46 -0300 (ADT) Received: from zmori.markir.net (121-72-79-187.dsl.telstraclear.net [121.72.79.187]) by smtp5.clear.net.nz (CLEAR Net Mail) with ESMTP id <0JLT00JW5BL65D30@smtp5.clear.net.nz> for pgsql-performance@postgresql.org; Fri, 27 Jul 2007 12:48:43 +1200 (NZST) Date: Fri, 27 Jul 2007 12:48:36 +1200 From: Mark Kirkwood Subject: Re: disk filling up In-reply-to: <009c01c7cfa0$ab526810$fc01a8c0@blaptop> To: Brandon Shalton Cc: pgsql-performance@postgresql.org Message-id: <46A940E4.40804@paradise.net.nz> MIME-version: 1.0 Content-type: text/plain; charset=ISO-8859-1; format=flowed Content-transfer-encoding: 7bit References: <009c01c7cfa0$ab526810$fc01a8c0@blaptop> User-Agent: Thunderbird 2.0.0.4 (X11/20070716) X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200707/380 X-Sequence-Number: 26064 Brandon Shalton wrote: > Hello all, > > My hard disk is filling up in the /base directory to where it has > consumed all 200gig of that drive. > > All the posts that i see keep saying move to a bigger drive, but at > some point a bigger drive would just get consumed. > > How can i keep the disk from filling up other than get like a half TB > setup just to hold the ./base/* folder > Two things come to mind: - Vacuum as already mentioned by others. - Temporary sort files from queries needing to sort massive amounts of data. But you need to help us out by supplying more info... Cheers Mark