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

From Andrew Dunstan
Subject Re: [DOCS] pg_total_relation_size() and CHECKPOINT
Date
Msg-id 47EAE45D.8050902@dunslane.net
Whole thread Raw
In response to Re: [DOCS] pg_total_relation_size() and CHECKPOINT  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: [DOCS] pg_total_relation_size() and CHECKPOINT
List pgsql-hackers

Tom Lane wrote:
> Andrew Dunstan <andrew@dunslane.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


pgsql-hackers by date:

Previous
From: Greg Smith
Date:
Subject: Re: Proposal: improve shutdown during online backup
Next
From: Tom Lane
Date:
Subject: Re: [DOCS] pg_total_relation_size() and CHECKPOINT