disk space usage unexpected - Mailing list pgsql-performance

From Rose Zhou
Subject disk space usage unexpected
Date
Msg-id 4891A2E2CDEF4CE6B6D7F7A4BD4F4D66@Cicero
Whole thread Raw
Responses Re: disk space usage unexpected
Re: disk space usage unexpected
Re: disk space usage unexpected
List 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


pgsql-performance by date:

Previous
From: Ben Chobot
Date:
Subject: Re: 8.1 -> 8.4 regression
Next
From: "Rose Zhou"
Date:
Subject: Auto Vacuum out of memory