disk space usage unexpected

From: "Rose Zhou" <rose(at)anatec(dot)com>
To: <pgsql-performance(at)postgresql(dot)org>
Subject: disk space usage unexpected
Date: 2010-02-15 19:59:51
Message-ID: 4891A2E2CDEF4CE6B6D7F7A4BD4F4D66@Cicero
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

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

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Rose Zhou 2010-02-15 20:20:44 Auto Vacuum out of memory
Previous Message Ben Chobot 2010-02-15 17:35:13 Re: 8.1 -> 8.4 regression