Skip site navigation (1) Skip section navigation (2)

Re: [DOCS] pg_total_relation_size() and CHECKPOINT

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 (view raw or flat)
Thread:
Lists: pgsql-docspgsql-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

In response to

Responses

pgsql-docs by date

Next:From: Tom LaneDate: 2008-03-27 01:08:56
Subject: Re: [DOCS] pg_total_relation_size() and CHECKPOINT
Previous:From: Tom LaneDate: 2008-03-26 15:41:32
Subject: Re: [DOCS] pg_total_relation_size() and CHECKPOINT

pgsql-hackers by date

Next:From: Tom LaneDate: 2008-03-27 01:08:56
Subject: Re: [DOCS] pg_total_relation_size() and CHECKPOINT
Previous:From: Greg SmithDate: 2008-03-26 23:54:50
Subject: Re: Proposal: improve shutdown during online backup

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group