: pgsql-performance@postgresql.org
Subject: Re: [PERFORM] disk space usage unexpected
On Feb 15, 2010, at 1:25 PM, Rose Zhou wrote:
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
On Feb 15, 2010, at 1:25 PM, Rose Zhou wrote:
> 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?
>
>
Yes, but it might bloat your index
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,..
: 15 February 2010 16:16
To: Rose Zhou
Cc: pgsql-performance@postgresql.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 u
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,...fil
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
