Re: Maintenance question / DB size anomaly...

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Kurt Overberg <kurt(at)hotdogrecords(dot)com>
Cc: Chris Browne <cbbrowne(at)acm(dot)org>, pgsql-performance(at)postgresql(dot)org
Subject: Re: Maintenance question / DB size anomaly...
Date: 2007-06-20 02:51:15
Message-ID: 1876.1182307875@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Kurt Overberg <kurt(at)hotdogrecords(dot)com> 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

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Greg Smith 2007-06-20 05:03:19 Re: Volunteer to build a configuration tool
Previous Message Kurt Overberg 2007-06-20 01:53:09 Re: Maintenance question / DB size anomaly...