Received: from localhost (unknown [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id 749E62E0191 for ; Fri, 14 Mar 2008 13:33:57 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024) with ESMTP id 08928-03 for ; Fri, 14 Mar 2008 13:33:46 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from mail.transas.com (mail.transas.com [82.140.75.150]) by postgresql.org (Postfix) with ESMTP id 4AF5A2E013F for ; Fri, 14 Mar 2008 13:33:47 -0300 (ADT) Received: from sol.transas.com (sol.transas.com [10.10.0.20]) by mail.transas.com (Postfix) with ESMTP id 5946A500970; Fri, 14 Mar 2008 19:33:38 +0300 (MSK) Content-class: urn:content-classes:message MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: quoted-printable X-MimeOLE: Produced By Microsoft Exchange V6.5 Subject: Re: [DOCS] pg_total_relation_size() and CHECKPOINT Date: Fri, 14 Mar 2008 19:33:37 +0300 Message-ID: <528853D3C5ED2C4AA8990B504BA7FB850106DF14@sol.transas.com> In-Reply-To: <19332.1205511560@sss.pgh.pa.us> X-MS-Has-Attach: X-MS-TNEF-Correlator: Thread-Topic: [DOCS] pg_total_relation_size() and CHECKPOINT Thread-Index: AciF7zIgstWzM9H6QpetWspKomVOIQAAVezQ From: "Zubkovsky, Sergey" To: "Tom Lane" Cc: X-Transas-MailScanner: Found to be clean X-Transas-MailScanner-From: sergey.zubkovsky@transas.com X-Transas-MailScanner-To: pgsql-hackers@postgresql.org, tgl@sss.pgh.pa.us X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200803/486 X-Sequence-Number: 115287 The previous results were received on PG 8.3 version: "PostgreSQL 8.3.0, compiled by Visual C++ build 1400" -----Original Message----- From: Tom Lane [mailto:tgl@sss.pgh.pa.us]=20 Sent: Friday, March 14, 2008 7:19 PM To: Zubkovsky, Sergey Cc: pgsql-docs@postgresql.org; pgsql-hackers@postgresql.org Subject: Re: [DOCS] pg_total_relation_size() and CHECKPOINT [ moved to -hackers --- see original thread here http://archives.postgresql.org/pgsql-docs/2008-03/msg00039.php ] "Zubkovsky, Sergey" writes: > Here is my example. Hmm ... on my Fedora machine I get the same result (704512) in all these cases, which is what I'd expect. (The exact value could vary across platforms, of course.) You said you were using the MinGW build --- maybe MinGW's version of stat(2) isn't trustworthy? regards, tom lane