disk space usage unexpected

From: Rose Zhou
Subject: disk space usage unexpected
Date: ,
Msg-id: 4891A2E2CDEF4CE6B6D7F7A4BD4F4D66@Cicero
(view: Whole thread, Raw)
Responses: Re: disk space usage unexpected  (Ben Chobot)
Re: disk space usage unexpected  ("Joshua D. Drake")
Re: disk space usage unexpected  ("Joshua D. Drake")
List: pgsql-performance

Tree view

disk space usage unexpected  ("Rose Zhou", )
 Re: disk space usage unexpected  (Ben Chobot, )
  Re: disk space usage unexpected  ("Rose Zhou", )
   Re: disk space usage unexpected  (Ben Chobot, )
    Re: disk space usage unexpected  ("Rose Zhou", )
 Re: disk space usage unexpected  ("Joshua D. Drake", )
 Re: disk space usage unexpected  ("Joshua D. Drake", )

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:

From: "Joshua D. Drake"
Date:
Subject: Re: disk space usage unexpected
From: "Joshua D. Drake"
Date:
Subject: Re: disk space usage unexpected