Re: [DOCS] pg_total_relation_size() and CHECKPOINT

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Andrew Dunstan <andrew(at)dunslane(dot)net>
Cc: 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, Magnus Hagander <magnus(at)hagander(dot)net>
Subject: Re: [DOCS] pg_total_relation_size() and CHECKPOINT
Date: 2008-03-27 04:13:42
Message-ID: 968.1206591222@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-docs pgsql-hackers

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?

regards, tom lane

In response to

Responses

Browse pgsql-docs by date

  From Date Subject
Next Message Magnus Hagander 2008-03-27 07:33:41 Re: [DOCS] pg_total_relation_size() and CHECKPOINT
Previous Message Andrew Dunstan 2008-03-27 03:25:51 Re: [DOCS] pg_total_relation_size() and CHECKPOINT

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Raney 2008-03-27 05:26:11 Planner/optimizer tool
Previous Message Tom Lane 2008-03-27 04:03:05 Re: Fix pg_dump dependency on postgres.h