Received: from localhost (maia-3.hub.org [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id 4CD759FB45A for ; Tue, 19 Jun 2007 23:51:24 -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 72821-01 for ; Tue, 19 Jun 2007 23:51:11 -0300 (ADT) 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 8D30B9FB324 for ; Tue, 19 Jun 2007 23:51:20 -0300 (ADT) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.14.1/8.14.1) with ESMTP id l5K2pFNl001877; Tue, 19 Jun 2007 22:51:15 -0400 (EDT) To: Kurt Overberg cc: Chris Browne , pgsql-performance@postgresql.org Subject: Re: Maintenance question / DB size anomaly... In-reply-to: <4D1C51F2-79EA-4468-BF2D-1D5591BD8A3D@hotdogrecords.com> References: <607iq0dlns.fsf@dba2.int.libertyrms.com> <1FF54A1D-9085-4C9B-81F3-D860FB132D44@hotdogrecords.com> <16441.1182288819@sss.pgh.pa.us> <18495.1182295570@sss.pgh.pa.us> <4D1C51F2-79EA-4468-BF2D-1D5591BD8A3D@hotdogrecords.com> Comments: In-reply-to Kurt Overberg message dated "Tue, 19 Jun 2007 21:53:09 -0400" Date: Tue, 19 Jun 2007 22:51:15 -0400 Message-ID: <1876.1182307875@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200706/400 X-Sequence-Number: 25433 Kurt Overberg writes: > Okay, I've grabbed pg_filedump and got it running on the appropriate > server. > I really have No Idea how to read its output though. Where does the > ctid from sl_log_1 > appear in the following listing? ctid is (block number, item number) > Block 0 ******************************************************** > BTree Meta Data: Magic (0x00053162) Version (2) > Root: Block (1174413) Level (3) > FastRoot: Block (4622) Level (1) This seems to be an index, not the sl_log_1 table. regards, tom lane