Received: from localhost (unknown [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id 989952E0096 for ; Thu, 27 Mar 2008 01:13: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 67142-05 for ; Thu, 27 Mar 2008 01:13:54 -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 B01992E00A2 for ; Thu, 27 Mar 2008 01:13:55 -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 m2R4DggJ000969; Thu, 27 Mar 2008 00:13:42 -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: <47EB13BF.8080301@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> <21662.1206546092@sss.pgh.pa.us> <47EAE45D.8050902@dunslane.net> <21044.1206580136@sss.pgh.pa.us> <47EB13BF.8080301@dunslane.net> Comments: In-reply-to Andrew Dunstan message dated "Wed, 26 Mar 2008 23:25:51 -0400" Date: Thu, 27 Mar 2008 00:13:42 -0400 Message-ID: <968.1206591222@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200803/1091 X-Sequence-Number: 115892 Andrew Dunstan writes: > I suspect that the size reported by stat() is a little delayed here, but > the file system is keeping proper track of it, so the lseek that tries > to extend the file fails at the right spot. Hmm. If it really works that way, one would hope Microsoft would've documented that someplace. Can anyone find a statement that Windows' stat() is not current? regards, tom lane