X-Original-To: pgsql-sql-postgresql.org@postgresql.org
Received: from localhost (mx1.hub.org [200.46.208.251])
	by postgresql.org (Postfix) with ESMTP id 109029FB20A
	for <pgsql-sql-postgresql.org@postgresql.org>;
	Thu, 27 Jul 2006 15:42:45 -0300 (ADT)
Received: from postgresql.org ([200.46.204.71])
	by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024)
	with ESMTP id 38564-05 for <pgsql-sql-postgresql.org@postgresql.org>;
	Thu, 27 Jul 2006 15:42:35 -0300 (ADT)
X-Greylist: from auto-whitelisted by SQLgrey-
Received: from exchange.g2switchworks.com (mail.g2switchworks.com
	[63.87.162.25]) by postgresql.org (Postfix) with ESMTP id D03199FB21A
	for <pgsql-sql@postgresql.org>; Thu, 27 Jul 2006 15:41:56 -0300 (ADT)
Received: from 10.10.1.37 ([10.10.1.37]) by exchange.g2switchworks.com
	([10.10.1.2]) with Microsoft Exchange Server HTTP-DAV ;
	Thu, 27 Jul 2006 18:41:54 +0000
Received: from state.g2switchworks.com by mail.g2switchworks.com;
	27 Jul 2006 13:41:54 -0500
Subject: Re: Disk is full, what's cool to get rid of?
From: Scott Marlowe <smarlowe@g2switchworks.com>
To: Jeff Frost <jeff@frostconsultingllc.com>
Cc: Erik Jones <erik@myemma.com>,
	General Postgresql List <pgsql-sql@postgresql.org>
In-Reply-To: 
 <Pine.LNX.4.64.0607270931280.11632@discord.home.frostconsultingllc.com>
References: <44C8E7EB.3040608@myemma.com>
	<Pine.LNX.4.64.0607270931280.11632@discord.home.frostconsultingllc.com>
Content-Type: text/plain
Content-Transfer-Encoding: 7bit
Message-Id: <1154025714.31664.95.camel@state.g2switchworks.com>
Mime-Version: 1.0
X-Mailer: Ximian Evolution 1.4.6 (1.4.6-2) 
Date: Thu, 27 Jul 2006 13:41:54 -0500
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=0.053 tagged_above=0 required=5 tests=AWL, SPF_PASS,
	UNPARSEABLE_RELAY
X-Spam-Level: 
X-Archive-Number: 200607/336
X-Sequence-Number: 25910

I can't tell you the number of times that little trick has saved my
life.

On Thu, 2006-07-27 at 11:32, Jeff Frost wrote:
> You can probably just "tune2fs -m 0 <device name>" to give yourself enough 
> space to get out of the jam before you go deleting things.  Then you might 
> want to vacuum full afterwards.
> 
> On Thu, 27 Jul 2006, Erik Jones wrote:
> 
> > Hello, quick question.  I've run into an issue with the disk that my 
> > development box is on filling up and preventing pretty much any writing 
> > (inserts, updates, deletes, etc...) from happening.  Other than some piddly 
> > text logs the db is pretty much the only thing on the box.  So, my question 
> > is:  what can I do to free space and run a full vacuum? (I was not the one 
> > who set up this box and there has been virtually no administration or 
> > maintenance on it that I know of...)  How about the WAL files in pg_xlog? 
> > How critical are they when no data on the system is critical in and of 
> > itself?  Any suggestions would be greatly appreciated...
> >
> >