Received: from maia.hub.org (unknown [200.46.204.183])
	by mail.postgresql.org (Postfix) with ESMTP id 91D31632BC5
	for <pgsql-performance-postgresql.org@mail.postgresql.org>;
	Mon, 15 Feb 2010 21:25:37 -0400 (AST)
Received: from mail.postgresql.org ([200.46.204.86])
	by maia.hub.org (mx1.hub.org [200.46.204.183]) (amavisd-maia,
	port 10024) with ESMTP id 97307-05-3
	for <pgsql-performance-postgresql.org@mail.postgresql.org>;
	Tue, 16 Feb 2010 01:25:26 +0000 (UTC)
X-Greylist: from auto-whitelisted by SQLgrey-1.7.6
Received: from spinlock.commandprompt.com (host-215.commandprompt.net
	[207.173.203.215])
	by mail.postgresql.org (Postfix) with ESMTP id 1198F632F66
	for <pgsql-performance@postgresql.org>;
	Mon, 15 Feb 2010 21:25:16 -0400 (AST)
Received: from localhost (localhost [127.0.0.1])
	by spinlock.commandprompt.com (Postfix) with ESMTP id 2AFD7348036;
	Mon, 15 Feb 2010 17:25:13 -0800 (PST)
Received: from spinlock.commandprompt.com ([127.0.0.1])
	by localhost (spinlock.commandprompt.com.commandprompt.com [127.0.0.1])
	(amavisd-new, port 10024)
	with ESMTP id 5pv0owNMcQ+1; Mon, 15 Feb 2010 17:25:13 -0800 (PST)
Received: from [192.168.1.100] (unknown [75.142.159.62])
	by spinlock.commandprompt.com (Postfix) with ESMTPSA id D4530348034;
	Mon, 15 Feb 2010 17:25:12 -0800 (PST)
Subject: Re: disk space usage unexpected
From: "Joshua D. Drake" <jd@commandprompt.com>
Reply-To: jd@commandprompt.com
To: Rose Zhou <rose@anatec.com>
Cc: pgsql-performance@postgresql.org
In-Reply-To: <4891A2E2CDEF4CE6B6D7F7A4BD4F4D66@Cicero>
References: <4891A2E2CDEF4CE6B6D7F7A4BD4F4D66@Cicero>
Content-Type: text/plain; charset="UTF-8"
Organization: Command Prompt, Inc.
Date: Mon, 15 Feb 2010 17:24:50 -0800
Message-ID: <1266283490.30755.212.camel@jd-desktop.unknown.charter.com>
Mime-Version: 1.0
X-Mailer: Evolution 2.28.1 
Content-Transfer-Encoding: 7bit
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=-0.185 tagged_above=-10 required=5
	tests=BAYES_40=-0.185
X-Spam-Level: 
X-Archive-Number: 201002/249
X-Sequence-Number: 37670

On Mon, 2010-02-15 at 14:59 -0500, Rose Zhou wrote:
> Good day,
> 
> I have a PostgreSQL 8.4 database installed on WinXP x64 with very heavy
> writing and updating on a partitioned table. Sometimes within one minute,
> there are tens of file with size=1,048,576kb (such as
> filenode.1,filenode.2,...filenode.43) created in the database subdirectory
> within PGDATA/base. 
> 
> This caused the disk space quickly used up. Is this expected?

Yes. Especially if autovacuum is not keeping up with the number of
updates.

Joshua D. Drake


> 
> Thanks for any information
> 
> 
> 
> Best Regards
> 
> Rose Zhou 
> 
> 


-- 
PostgreSQL.org Major Contributor
Command Prompt, Inc: http://www.commandprompt.com/ - 503.667.4564
Consulting, Training, Support, Custom Development, Engineering
Respect is earned, not gained through arbitrary and repetitive use or Mr. or Sir.