Re: Maintenance question / DB size anomaly...

[Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>]

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