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 indexes. Do
: 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
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
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
: 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 updating on a partitioned
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