Received: from localhost (unknown [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id 872642E0082 for ; Wed, 26 Mar 2008 11:01:39 -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 45064-04 for ; Wed, 26 Mar 2008 11:01:21 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from alexis.jtlnet.com (alexis.jtlnet.com [69.36.9.81]) by postgresql.org (Postfix) with ESMTP id E5B1E2E005A for ; Wed, 26 Mar 2008 11:01:29 -0300 (ADT) Received: from [192.168.10.103] (cpe-075-177-177-228.nc.res.rr.com [::ffff:75.177.177.228]) (TLS: TLSv1/SSLv3,256bits,AES256-SHA) by alexis.jtlnet.com with esmtp; Wed, 26 Mar 2008 09:55:40 -0400 id 0007FC5B.47EA55DD.000021ED Message-ID: <47EA5602.6060605@dunslane.net> Date: Wed, 26 Mar 2008 09:56:18 -0400 From: Andrew Dunstan User-Agent: Mozilla/5.0 (X11; U; Linux x86_64; en-US; rv:1.8.0.12) Gecko/20071019 Fedora/1.0.9-3.fc6 pango-text SeaMonkey/1.0.9 MIME-Version: 1.0 To: Alvaro Herrera CC: Tom Lane , Gregory Stark , "Zubkovsky, Sergey" , pgsql-hackers@postgresql.org, Magnus Hagander Subject: Re: [DOCS] pg_total_relation_size() and CHECKPOINT 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> In-Reply-To: <20080326132250.GK5895@alvh.no-ip.org> Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200803/1036 X-Sequence-Number: 115837 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. cheers andrew