Received: from localhost (unknown [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id 2485D2E0145; Fri, 14 Mar 2008 13:20:03 -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 05308-06; Fri, 14 Mar 2008 13:19:21 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by postgresql.org (Postfix) with ESMTP id 4C9F02E0164; Fri, 14 Mar 2008 13:19:22 -0300 (ADT) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.14.2/8.14.2) with ESMTP id m2EGJKcE019333; Fri, 14 Mar 2008 12:19:20 -0400 (EDT) To: "Zubkovsky, Sergey" cc: pgsql-docs@postgresql.org, pgsql-hackers@postgresql.org Subject: Re: pg_total_relation_size() and CHECKPOINT In-reply-to: <528853D3C5ED2C4AA8990B504BA7FB850106DF13@sol.transas.com> References: <528853D3C5ED2C4AA8990B504BA7FB850106DF13@sol.transas.com> Comments: In-reply-to "Zubkovsky, Sergey" message dated "Fri, 14 Mar 2008 18:23:22 +0300" Date: Fri, 14 Mar 2008 12:19:20 -0400 Message-ID: <19332.1205511560@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200803/43 X-Sequence-Number: 4855 [ 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