Re: Maintenance question / DB size anomaly... - Mailing list pgsql-performance

Kurt Overberg <kurt@hotdogrecords.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