Re: Heap page diagnostic/test functions (WIP) - Mailing list pgsql-patches

From Gregory Stark
Subject Re: Heap page diagnostic/test functions (WIP)
Date
Msg-id 87hcszcqlj.fsf@stark.xeocode.com
Whole thread Raw
In response to Re: Heap page diagnostic/test functions (WIP)  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-patches
"Tom Lane" <tgl@sss.pgh.pa.us> writes:

> Exactly what will these allow that you can't do with inspection of ctid
> etc?  (I suspect your answer will be "can't see infomask"

For testing the packed varlena stuff it would have been handy to be able to
see the length of tuples on disk. I made do with pg_column_size(foo.*) but
it's not exactly the same thing I don't think.

And I could see for debugging HOT and vacuum it would be helpful to see the
physical layout of the tuples in the page. Ie, the offsets of each tuple
(which Simon's function didn't actually output last I saw, but would be nice
if it were added).

--
  Gregory Stark
  EnterpriseDB          http://www.enterprisedb.com

pgsql-patches by date:

Previous
From: Tom Lane
Date:
Subject: Re: Heap page diagnostic/test functions (WIP)
Next
From: "Mike Rylander"
Date:
Subject: xml2 contrib patch supporting default XML namespaces