Re: [DOCS] pg_total_relation_size() and CHECKPOINT - Mailing list pgsql-hackers

From Magnus Hagander
Subject Re: [DOCS] pg_total_relation_size() and CHECKPOINT
Date
Msg-id 20080327083341.260e222e@mha-laptop
Whole thread Raw
In response to Re: [DOCS] pg_total_relation_size() and CHECKPOINT  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
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


pgsql-hackers by date:

Previous
From: Tom Raney
Date:
Subject: Planner/optimizer tool
Next
From: "Albe Laurenz"
Date:
Subject: Re: Proposal: improve shutdown during online backup