Hacker News new | ask | show | jobs
by arconis987 2100 days ago
This is fantastic! Love the parallel vacuum feature, which should help my team’s sanity with a write-heavy workload.

Does anyone know when the zheap storage system will be released? This system will apparently obviate the need for vacuums all together since old row version information will be kept in an undo log instead of in the heap. This will be a game changer for us.

1 comments

It's a bit more complicated than that. You will also notice another release note item in PG13 that says "Allow inserts, not only updates and deletes, to trigger vacuuming activity in autovacuum", which is because vacuum is not only about cleaning up deleted or rolled-back rows, but also transaction ID wraparound. Making that go away is also a dream of many, but it's a different (or additional) project than a new storage system.