Re: [DOCS] pg_total_relation_size() and CHECKPOINT

Поиск
Список
Период
Сортировка
От Magnus Hagander
Тема Re: [DOCS] pg_total_relation_size() and CHECKPOINT
Дата
Msg-id 20080327083341.260e222e@mha-laptop
обсуждение исходный текст
Ответ на Re: [DOCS] pg_total_relation_size() and CHECKPOINT  (Tom Lane <tgl@sss.pgh.pa.us>)
Список 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 по дате отправления:

Предыдущее
От: Tom Raney
Дата:
Сообщение: Planner/optimizer tool
Следующее
От: "Albe Laurenz"
Дата:
Сообщение: Re: Proposal: improve shutdown during online backup