From: Rose Zhou <rose@anatec.com>
To: pgsql-performance@postgresql.org
Subject: disk space usage unexpected
Date: Mon, 15 Feb 2010 14:59:51 -0500
Message-ID: <4891A2E2CDEF4CE6B6D7F7A4BD4F4D66@Cicero> (raw)
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?
Thanks for any information
Best Regards
Rose Zhou
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: rose@anatec.com
Subject: Re: disk space usage unexpected
In-Reply-To: <4891A2E2CDEF4CE6B6D7F7A4BD4F4D66@Cicero>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox