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,...filenode.43) created in the database subdirectory > within PGDATA/base. > > This caused the disk space quickly used up. Is this expected?
Yes. Especially if autovacuum is not keeping up with the number of updates. Joshua D. Drake > > Thanks for any information > > > > Best Regards > > Rose Zhou > > -- PostgreSQL.org Major Contributor Command Prompt, Inc: http://www.commandprompt.com/ - 503.667.4564 Consulting, Training, Support, Custom Development, Engineering Respect is earned, not gained through arbitrary and repetitive use or Mr. or Sir. -- Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
