Re: disk space usage unexpected

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(at)silentmedia(dot)com]
Sent: 15 February 2010 16:16
To: Rose Zhou
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: [PERFORM] disk space usage unexpected

On 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.