Content-class: urn:content-classes:message
MIME-Version: 1.0
Content-Type: text/plain;
	charset="us-ascii"
Content-Transfer-Encoding: quoted-printable
Subject: Re: [DOCS] pg_total_relation_size() and CHECKPOINT
Date: Wed, 26 Mar 2008 17:44:16 +0300
Message-ID: <528853D3C5ED2C4AA8990B504BA7FB850106DF29@sol.transas.com>
In-Reply-To: <47EA5602.6060605@dunslane.net>
Thread-Topic: [HACKERS] [DOCS] pg_total_relation_size() and CHECKPOINT
Thread-Index: AciPSTv4G1+wnIhIQ8en8AXpo1fFrgABW8dg
From: "Zubkovsky, Sergey" <Sergey.Zubkovsky@transas.com>
To: "Andrew Dunstan" <andrew@dunslane.net>,
	"Alvaro Herrera" <alvherre@commandprompt.com>
Cc: "Tom Lane" <tgl@sss.pgh.pa.us>, "Gregory Stark" <stark@enterprisedb.com>,
	<pgsql-hackers@postgresql.org>, "Magnus Hagander" <magnus@hagander.net>


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]=20
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:
>
>  =20
>> 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.
>>    =20
>
> Has this been examined by a Windows hacker?
>
>  =20

If someone can suggest a test program I'll be happy to run it.

cheers

andrew