From: Joshua D. Drake <jd@commandprompt.com>
To: Rose Zhou <rose@anatec.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: disk space usage unexpected
Date: Mon, 15 Feb 2010 17:24:50 -0800
Message-ID: <1266283490.30755.212.camel@jd-desktop.unknown.charter.com> (raw)
In-Reply-To: <4891A2E2CDEF4CE6B6D7F7A4BD4F4D66@Cicero>
References: <4891A2E2CDEF4CE6B6D7F7A4BD4F4D66@Cicero>
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.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: jd@commandprompt.com, rose@anatec.com
Subject: Re: disk space usage unexpected
In-Reply-To: <1266283490.30755.212.camel@jd-desktop.unknown.charter.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox