On Sat, Sep 30, 2017 at 2:10 AM, konstantin knizhnik <k.knizh...@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
