Re: preserving forensic information when we freeze

Поиск
Список
Период
Сортировка
От Alvaro Herrera
Тема Re: preserving forensic information when we freeze
Дата
Msg-id 20131220131313.GQ11006@eldon.alvh.no-ip.org
обсуждение исходный текст
Ответ на Re: preserving forensic information when we freeze  (Robert Haas <robertmhaas@gmail.com>)
Список 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 по дате отправления:

Предыдущее
От: Andres Freund
Дата:
Сообщение: Re: preserving forensic information when we freeze
Следующее
От: Alvaro Herrera
Дата:
Сообщение: Re: New option for pg_basebackup, to specify a different directory for pg_xlog