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:be...@silentmedia.com] Sent: 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 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.
