Thanks Ben:
I will adjust the auto vacuum parameters. It is on now,
maybe not frequently enough.
How to get the disk space back to OS? Will a Vacuum
Full Verbose get the disk space back to OS?
Best Regards
Rose Zhou
From: Ben Chobot [mailto:bench@xxxxxxxxxxxxxxx]
Sent: 15 February 2010 16:16
To: Rose Zhou
Cc: pgsql-performance@xxxxxxxxxxxxxx
Subject: Re: disk space usage unexpectedOn Feb 15, 2010, at 11:59 AM, 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?
It's expected if you're doing lots of inserts, and/or lots of updates or deletes without an appropriate amount of vacuuming.
