Re: [HACKERS] pg_prepared_xact_status - Mailing list pgsql-hackers

From Robert Haas
Subject Re: [HACKERS] pg_prepared_xact_status
Date
Msg-id CA+TgmobNLmRW-9FX0ajoaq69WYCncuoAafBzMWhHnjGfw+P8Gw@mail.gmail.com
Whole thread Raw
In response to Re: [HACKERS] pg_prepared_xact_status  (konstantin knizhnik <k.knizhnik@postgrespro.ru>)
Responses Re: [HACKERS] pg_prepared_xact_status
Re: [HACKERS] pg_prepared_xact_status
List pgsql-hackers
On Sat, Sep 30, 2017 at 2:10 AM, konstantin knizhnik
<k.knizhnik@postgrespro.ru> wrote:
> txid_status() also not always be able to return status of transaction (if wraparound happen).
> But it is still considered as one of the key features of 10 (transaction traceability...).

Not by me.  It's a feature, though, for sure.  It's also a LOT more
stable than what you're proposing.  Even on a busy system, it takes a
while to go through 200 million transactions; you probably can't
realistically do that in under an hour, and you'll probably raise the
200 million transaction limit if you're anywhere close to that rate.
In practice, you'll almost always be able to look up transactions for
several days, and often weeks or months.  With what you're proposing
here, the information could disappear nearly instantly.  I can't see
how that works out to a usable feature.

-- 
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

pgsql-hackers by date:

Previous
From: Daniel Gustafsson
Date:
Subject: Re: [HACKERS] Push down more UPDATEs/DELETEs in postgres_fdw
Next
From: Michael Paquier
Date:
Subject: Re: [HACKERS] pg_prepared_xact_status