| From: | Andrew Dunstan <andrew(at)dunslane(dot)net> |
|---|---|
| To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
| 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 00:03:41 |
| Message-ID: | 47EAE45D.8050902@dunslane.net |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-docs pgsql-hackers |
Tom Lane wrote:
> Andrew Dunstan <andrew(at)dunslane(dot)net> writes:
>
>> Alvaro Herrera wrote:
>>
>>> Tom Lane wrote:
>>>
>>>> The real question here is whether Windows' stat() is telling the truth
>>>> about how much filesystem space has actually been allocated to a file.
>>>> It seems entirely possible that it's not; but if it is, then I think we
>>>> have a problem.
>>>>
>
>
>>> Has this been examined by a Windows hacker?
>>>
>
>
>> If someone can suggest a test program I'll be happy to run it.
>>
>
> One thing that would be good is just to see who else can reproduce
> the original observation:
> http://archives.postgresql.org/pgsql-docs/2008-03/msg00041.php
>
> It might occur only on some versions of Windows, for instance.
>
>
>
I have reproduced it in XP-Pro/SP2 running in a VMWare machine on an FC6
host.
cheers
andrew
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2008-03-27 01:08:56 | Re: [DOCS] pg_total_relation_size() and CHECKPOINT |
| Previous Message | Tom Lane | 2008-03-26 15:41:32 | Re: [DOCS] pg_total_relation_size() and CHECKPOINT |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2008-03-27 01:08:56 | Re: [DOCS] pg_total_relation_size() and CHECKPOINT |
| Previous Message | Greg Smith | 2008-03-26 23:54:50 | Re: Proposal: improve shutdown during online backup |