News for hackers. Stuff that matters.

A comment on Improved vacuum in PostgreSQL 13. Parent comment

Re:Improved vacuum in PostgreSQL 13 by marcosdumay on Tuesday May 12, 2020 @10:21AM (#23154256)
Today I just woke up to find yet another "ORA-01555: snapshot too old" on something I left running overnight.

Honestly, performance isn't as important as the capacity of getting an atomic snapshot of your data with any reliability.

[ Parent | on HN ]
Re:Improved vacuum in PostgreSQL 13 by ComodoHacker on Tuesday May 12, 2020 @01:28PM (#23156775)
Avoiding ORA-01555 is a matter of properly sizing your undo.
[ Parent | on HN ]
Re:Improved vacuum in PostgreSQL 13 by marcosdumay on Tuesday May 12, 2020 @04:16PM (#23159143)
And a matter of not getting any task that is slower than what you expected.
[ Parent | on HN ]