News for hackers. Stuff that matters.

A comment on How long will a 64 bit Transaction-ID last in PostgreSQL?.

Re:How long will a 64 bit Transaction-ID last in PostgreSQL? by kostaw on Tuesday February 05, 2019 @03:46AM (#19083805)
Just imagine running `VACUUM` on that table that wrote 1M rows/seconds for 300 years and now you need to vaccuum quick because the transaction ids will wrap around next year...
[ Parent | on HN ]
Re:How long will a 64 bit Transaction-ID last in PostgreSQL? by Aeolun on Tuesday February 05, 2019 @05:24AM (#19084113)
Unless I’m missing something, you’d still have some 299700 years for your VACUUM to complete.
[ Parent | on HN ]