Received: from localhost (unknown [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id C5A522E005F for ; Wed, 26 Mar 2008 12:42:03 -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 75467-05 for ; Wed, 26 Mar 2008 12:41:44 -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 30DB92E0057 for ; Wed, 26 Mar 2008 12:41:44 -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 m2QFfWj9021663; Wed, 26 Mar 2008 11:41:32 -0400 (EDT) To: Andrew Dunstan cc: Alvaro Herrera , Gregory Stark , "Zubkovsky, Sergey" , pgsql-hackers@postgresql.org, Magnus Hagander Subject: Re: [DOCS] pg_total_relation_size() and CHECKPOINT In-reply-to: <47EA5602.6060605@dunslane.net> References: <528853D3C5ED2C4AA8990B504BA7FB850106DF14@sol.transas.com> <21561.1205515308@sss.pgh.pa.us> <87myp1f9a7.fsf@oxford.xeocode.com> <24576.1205524921@sss.pgh.pa.us> <20080326132250.GK5895@alvh.no-ip.org> <47EA5602.6060605@dunslane.net> Comments: In-reply-to Andrew Dunstan message dated "Wed, 26 Mar 2008 09:56:18 -0400" Date: Wed, 26 Mar 2008 11:41:32 -0400 Message-ID: <21662.1206546092@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200803/1050 X-Sequence-Number: 115851 Andrew Dunstan writes: > Alvaro Herrera wrote: >> Tom Lane wrote: >>> The real question here is whether Windows' stat() is telling the truth >>> about how much filesystem space has actually been allocated to a file. >>> It seems entirely possible that it's not; but if it is, then I think we >>> have a problem. >> Has this been examined by a Windows hacker? > If someone can suggest a test program I'll be happy to run it. One thing that would be good is just to see who else can reproduce the original observation: http://archives.postgresql.org/pgsql-docs/2008-03/msg00041.php It might occur only on some versions of Windows, for instance. regards, tom lane