Received: from localhost (maia-3.hub.org [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id C77FE9FB68E for ; Thu, 26 Jul 2007 11:37:30 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024) with ESMTP id 17898-03 for ; Thu, 26 Jul 2007 11:37:18 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from mir3-fs.mir3.com (mail.mir3.com [65.208.188.100]) by postgresql.org (Postfix) with ESMTP id C9C649FB55C for ; Thu, 26 Jul 2007 11:37:26 -0300 (ADT) Received: MIR3-FS.mir3.com 172.16.1.11 from 172.16.2.68 172.16.2.68 via HTTP with MS-WebStorage 6.0.6249 Received: from archimedes by MIR3-FS.mir3.com; 26 Jul 2007 07:37:23 -0700 Subject: Re: disk filling up From: Mark Lewis To: Brandon Shalton Cc: pgsql-performance@postgresql.org In-Reply-To: <009c01c7cfa0$ab526810$fc01a8c0@blaptop> References: <009c01c7cfa0$ab526810$fc01a8c0@blaptop> Content-Type: text/plain Content-Transfer-Encoding: 7bit Organization: MIR3, Inc. Date: Thu, 26 Jul 2007 07:37:23 -0700 Message-Id: <1185460643.19184.24.camel@archimedes> Mime-Version: 1.0 X-Mailer: Evolution 2.8.1 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200707/363 X-Sequence-Number: 26047 On Thu, 2007-07-26 at 09:18 -0700, 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 Ummm, don't put more 200G worth of data in there? :) You didn't give us any information about what you're using the database for, why you think that using 200G is excessive, what version of the database you're running, stuff like that. So really there's nothing that we can help you out with, except for the normal "read the manual about vacuuming and make sure you're doing it" newbie answer. -- Mark