Received: from maia.hub.org (unknown [200.46.204.183]) by mail.postgresql.org (Postfix) with ESMTP id F388B633932 for ; Mon, 15 Feb 2010 16:00:33 -0400 (AST) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 44713-02-9 for ; Mon, 15 Feb 2010 20:00:23 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from appserver.anatec.local (anatec-adsl.demon.co.uk [80.177.51.9]) by mail.postgresql.org (Postfix) with SMTP id 78965633574 for ; Mon, 15 Feb 2010 15:59:53 -0400 (AST) Received: from Cicero ([69.171.137.171]) by appserver.anatec.local with Microsoft SMTPSVC(6.0.3790.3959); Mon, 15 Feb 2010 19:59:39 +0000 From: "Rose Zhou" To: Subject: disk space usage unexpected Date: Mon, 15 Feb 2010 14:59:51 -0500 Message-ID: <4891A2E2CDEF4CE6B6D7F7A4BD4F4D66@Cicero> MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit X-Mailer: Microsoft Office Outlook 11 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.5579 thread-index: AcqueW0gfq8ikitPTRGJxfTQ84Yz5w== X-OriginalArrivalTime: 15 Feb 2010 19:59:40.0218 (UTC) FILETIME=[689261A0:01CAAE79] X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-0.185 tagged_above=-10 required=5 tests=BAYES_40=-0.185 X-Spam-Level: X-Archive-Number: 201002/245 X-Sequence-Number: 37666 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