On 2025-Nov-04, Tom Lane wrote:
> It is not. The reason ROLLBACK is essentially free in Postgres
> is that some of the ensuing cleanup work gets done during
> subsequent table accesses. Some other DBMSes do that differently,
> but that's our choice and we're not likely to revisit it.
At least, it's the choice we have made in heapam. It's possible to make
different choices for other table AMs -- for instance, I bet OrioleDB
has made a different choice here, because of its claim that vacuum is
not needed.
--
Álvaro Herrera Breisgau, Deutschland — https://www.EnterpriseDB.com/
"El hombre nunca sabe de lo que es capaz hasta que lo intenta" (C. Dickens)