Re: tracking commit timestamps

From: Robert Haas <robertmhaas(at)gmail(dot)com>
To: Petr Jelinek <petr(at)2ndquadrant(dot)com>
Cc: Steve Singer <steve(at)ssinger(dot)info>, Andres Freund <andres(at)2ndquadrant(dot)com>, Jim Nasby <Jim(dot)Nasby(at)bluetreble(dot)com>, Michael Paquier <michael(dot)paquier(at)gmail(dot)com>, Anssi Kääriäinen <anssi(dot)kaariainen(at)thl(dot)fi>, Alvaro Herrera <alvherre(at)2ndquadrant(dot)com>, Simon Riggs <simon(at)2ndquadrant(dot)com>, Heikki Linnakangas <hlinnakangas(at)vmware(dot)com>, Pg Hackers <pgsql-hackers(at)postgresql(dot)org>, Jaime Casanova <jaime(at)2ndquadrant(dot)com>
Subject: Re: tracking commit timestamps
Date: 2014-11-08 02:05:09
Message-ID: CA+TgmoYK7qgLST35Azt+tuqK=eiP1JYwYJuRerdzcUzVHyiWJg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers pgsql-www

On Fri, Nov 7, 2014 at 7:07 PM, Petr Jelinek <petr(at)2ndquadrant(dot)com> wrote:
> The list of what is useful might be long,

That's FUD. It might also be short.

> but we can't have everything there
> as there are space constraints, and LSN is another 8 bytes and I still want
> to have some bytes for storing the "origin" or whatever you want to call it
> there, as that's the one I personally have biggest use-case for.
> So this would be ~24bytes per txid already, hmm I wonder if we can pull some
> tricks to lower that a bit.

It won't do to say "let's do the things that I want, and foreclose
forever the things that other people want". I find it quite hard to
believe that 16 bytes per transaction is a perfectly tolerable
overhead but 24 bytes per transaction will break the bank. But if
that is really true then we ought to reject this patch altogether,
because it's unacceptable, in any arena, for a patch that only
benefits extensions to consume all of the available bit-space in,
leaving none for future core needs.

--
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Robert Haas 2014-11-08 02:10:41 Re: Sequence Access Method WIP
Previous Message Peter Eisentraut 2014-11-08 02:03:07 Re: pg_basebackup fails with long tablespace paths

Browse pgsql-www by date

  From Date Subject
Next Message Petr Jelinek 2014-11-08 10:35:17 Re: tracking commit timestamps
Previous Message Petr Jelinek 2014-11-08 00:07:51 Re: tracking commit timestamps