News for hackers. Stuff that matters.
Re:Improved vacuum in PostgreSQL 13 by balfirevic on Tuesday May 12, 2020 @09:10AM (#23153559)
As far as I understand, the trade-off of storing stale rows in a separate place is that you need to bring them back if the transaction rolls back, making rollbacks more expensive.

Also, you need to copy entire row before updating it or deleting it, not sure how significant this cost is in practice.

Re:Improved vacuum in PostgreSQL 13 by ComodoHacker on Tuesday May 12, 2020 @01:18PM (#23156609)
Yes, but expansive rollbacks are acceptable as they are very rare in production.