From: Magnus Hagander <magnus@hagander.net>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: Andrew Dunstan <andrew@dunslane.net>
Cc: Alvaro Herrera <alvherre@commandprompt.com>
Cc: Gregory Stark <stark@enterprisedb.com>
Cc: Zubkovsky, Sergey <Sergey.Zubkovsky@transas.com>
Cc: pgsql-hackers@postgresql.org
Subject: Re: [DOCS] pg_total_relation_size() and CHECKPOINT
Date: Thu, 27 Mar 2008 08:33:41 +0100
Message-ID: <20080327083341.260e222e@mha-laptop> (raw)
In-Reply-To: <968.1206591222@sss.pgh.pa.us>
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>
<968.1206591222@sss.pgh.pa.us>
On Thu, 27 Mar 2008 00:13:42 -0400
Tom Lane <tgl@sss.pgh.pa.us> wrote:
> Andrew Dunstan <andrew@dunslane.net> 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?
I'm not in a position to test it myself now (doing training, and then
I'll be off to pg-east...), but it'd be interesting to see if it acts
the same way with GetFileSize(), or if it's just stat()...
/Magnus
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-docs@postgresql.org
Cc: magnus@hagander.net, tgl@sss.pgh.pa.us, andrew@dunslane.net, alvherre@commandprompt.com, stark@enterprisedb.com, Sergey.Zubkovsky@transas.com, pgsql-hackers@postgresql.org
Subject: Re: [DOCS] pg_total_relation_size() and CHECKPOINT
In-Reply-To: <20080327083341.260e222e@mha-laptop>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox