| From: | Magnus Hagander <magnus(at)hagander(dot)net> |
|---|---|
| To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
| Cc: | Andrew Dunstan <andrew(at)dunslane(dot)net>, Alvaro Herrera <alvherre(at)commandprompt(dot)com>, Gregory Stark <stark(at)enterprisedb(dot)com>, "Zubkovsky, Sergey" <Sergey(dot)Zubkovsky(at)transas(dot)com>, pgsql-hackers(at)postgresql(dot)org |
| Subject: | Re: [DOCS] pg_total_relation_size() and CHECKPOINT |
| Date: | 2008-03-27 07:33:41 |
| Message-ID: | 20080327083341.260e222e@mha-laptop |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-docs pgsql-hackers |
On Thu, 27 Mar 2008 00:13:42 -0400
Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
> Andrew Dunstan <andrew(at)dunslane(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Alvaro Herrera | 2008-03-27 11:14:57 | Re: [DOCS] pg_total_relation_size() and CHECKPOINT |
| Previous Message | Tom Lane | 2008-03-27 04:13:42 | Re: [DOCS] pg_total_relation_size() and CHECKPOINT |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Albe Laurenz | 2008-03-27 07:51:40 | Re: Proposal: improve shutdown during online backup |
| Previous Message | Tom Raney | 2008-03-27 05:26:11 | Planner/optimizer tool |