On Thu, Jan 2, 2014 at 2:56 PM, Tom Lane <t...@sss.pgh.pa.us> wrote: > Robert Haas <robertmh...@gmail.com> writes: >> On Thu, Jan 2, 2014 at 2:44 PM, Tom Lane <t...@sss.pgh.pa.us> wrote: >>> As I commented to Robert, the page-at-a-time behavior of pageinspect >>> is not an API detail we'd want to copy for this. I envision something >>> like >>> >>> select hdr.*, foo.* >>> from tuple_header_details('foo'::regclass) as hdr >>> left join foo on hdr.ctid = foo.ctid; >>> >>> On a large table you might want a version that restricts its scan >>> to pages M through N, but that's just optimization. More useful >>> would be to improve the planner's intelligence about joins on ctid ... > >> /me blinks. > >> Surely you're not serious. That's going to scan the whole darn table >> even if we only want the details for one row. > > And? The complaint about the other function was that it was inefficient > when getting the details for a whole table, so I don't think you can > complain about an approach that handles that case well. Use the other > function if you just want info for one row (that you can see).
Well, that's fair enough. I don't mind having two functions. Should the whole-table function also include invisible tuples? -- Robert Haas EnterpriseDB: http://www.enterprisedb.com The Enterprise PostgreSQL Company -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers