Received: from localhost (unknown [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id C85FD2E0233 for ; Fri, 14 Mar 2008 14:21:59 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024) with ESMTP id 26726-03 for ; Fri, 14 Mar 2008 14:21:48 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by postgresql.org (Postfix) with ESMTP id 72DBC2E02C8 for ; Fri, 14 Mar 2008 14:21:50 -0300 (ADT) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.14.2/8.14.2) with ESMTP id m2EHLnLQ021562; Fri, 14 Mar 2008 13:21:49 -0400 (EDT) To: "Zubkovsky, Sergey" cc: pgsql-hackers@postgresql.org Subject: Re: [DOCS] pg_total_relation_size() and CHECKPOINT In-reply-to: <528853D3C5ED2C4AA8990B504BA7FB850106DF14@sol.transas.com> References: <528853D3C5ED2C4AA8990B504BA7FB850106DF14@sol.transas.com> Comments: In-reply-to "Zubkovsky, Sergey" message dated "Fri, 14 Mar 2008 19:33:37 +0300" Date: Fri, 14 Mar 2008 13:21:48 -0400 Message-ID: <21561.1205515308@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200803/491 X-Sequence-Number: 115292 "Zubkovsky, Sergey" writes: > The previous results were received on PG 8.3 version: > "PostgreSQL 8.3.0, compiled by Visual C++ build 1400" Hmm. I find the whole thing fairly worrisome, because what it suggests is that Windows isn't actually allocating file space during smgrextend, which would mean that we'd be prone to running out of disk space at unfortunate times --- like during a checkpoint, after we've already promised the client the data is committed. Can any Windows hackers look into this and find out what's really happening? regards, tom lane