| From: | "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com> |
|---|---|
| To: | Rose Zhou <rose(at)anatec(dot)com> |
| Cc: | pgsql-performance(at)postgresql(dot)org |
| Subject: | Re: disk space usage unexpected |
| Date: | 2010-02-16 01:24:50 |
| Message-ID: | 1266283490.30755.212.camel@jd-desktop.unknown.charter.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
On Mon, 2010-02-15 at 14:59 -0500, 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?
Yes. Especially if autovacuum is not keeping up with the number of
updates.
Joshua D. Drake
>
> Thanks for any information
>
>
>
> Best Regards
>
> Rose Zhou
>
>
--
PostgreSQL.org Major Contributor
Command Prompt, Inc: http://www.commandprompt.com/ - 503.667.4564
Consulting, Training, Support, Custom Development, Engineering
Respect is earned, not gained through arbitrary and repetitive use or Mr. or Sir.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | lionel duboeuf | 2010-02-16 10:26:18 | Re: Almost infinite query -> Different Query Plan when changing where clause value |
| Previous Message | Rose Zhou | 2010-02-15 21:25:00 | Re: disk space usage unexpected |