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. -- Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
