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

From Zubkovsky, Sergey
Subject Re: [DOCS] pg_total_relation_size() and CHECKPOINT
Date
Msg-id 528853D3C5ED2C4AA8990B504BA7FB850106DF29@sol.transas.com
Whole thread Raw
In response to Re: [DOCS] pg_total_relation_size() and CHECKPOINT  (Andrew Dunstan <andrew@dunslane.net>)
List pgsql-hackers
Can anybody tell me how filesystem space is allocated and point me to
the sources if it's possible?
I have some experience with programming for Windows and I'll try to
investigate this problem.


-----Original Message-----
From: Andrew Dunstan [mailto:andrew@dunslane.net]
Sent: Wednesday, March 26, 2008 4:56 PM
To: Alvaro Herrera
Cc: Tom Lane; Gregory Stark; Zubkovsky, Sergey;
pgsql-hackers@postgresql.org; Magnus Hagander
Subject: Re: [HACKERS] [DOCS] pg_total_relation_size() and CHECKPOINT



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.

cheers

andrew


pgsql-hackers by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: Array behavior oddities
Next
From: "Xiao Meng"
Date:
Subject: [GSoC] Need for advice on improving hash index performance