Re: preserving forensic information when we freeze - Mailing list pgsql-hackers

From Alvaro Herrera
Subject Re: preserving forensic information when we freeze
Date
Msg-id 20131220131313.GQ11006@eldon.alvh.no-ip.org
Whole thread Raw
In response to Re: preserving forensic information when we freeze  (Robert Haas <robertmhaas@gmail.com>)
List pgsql-hackers
Robert Haas escribió:

> Maybe what we should do is add a function something like
> pg_tuple_header(tableoid, ctid) that returns a record, maybe something
> like (rawxmin xid, rawxmax xid, rawcid cid, infomask int, infomask2
> int, hoff int).  Or perhaps some slightly more cooked version of that
> information.  And then delete the xmin, xmax, cmin, and cmax system
> columns.  That'd save significantly on pg_attribute entries while, at
> the same time, actually providing more information than we do today.

+1 for this general idea.  I proposed this some time ago and got shot
down because of pageinspect.  I don't know about taking the system
columns out completely -- not sure how much third party code we're going
to break that way, certainly a lot -- but the extra functionality would
be useful nonetheless.

-- 
Álvaro Herrera                http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training & Services



pgsql-hackers by date:

Previous
From: Andres Freund
Date:
Subject: Re: preserving forensic information when we freeze
Next
From: Alvaro Herrera
Date:
Subject: Re: New option for pg_basebackup, to specify a different directory for pg_xlog