Improved vacuum in PostgreSQL 13

Re:Improved vacuum in PostgreSQL 13 by jasonwatkinspdx on Tuesday May 12, 2020 @11:34AM (#23155078)

This is somewhat confused/mistaken.

There are several successful databases that use in page MVCC storage. I'd suggest going through Andy Pavlo's slide decks for a summary: https://15721.courses.cs.cmu.edu/spring2020/, in particular slide 33 from lecture 3 has a summary. Also there are papers wheree his group directly benchmarks the various design alternatives within their test database, Peloton.

The TL;DR, is there's a lot of details to how this stuff works, many tradeoffs involved, and it's by no means whatsoever clear that Postgres has somehow made the wrong choice.

[ Parent | on HN ]

Re:Improved vacuum in PostgreSQL 13 by ComodoHacker on Tuesday May 12, 2020 @01:23PM (#23156697)

Thank you for the link, I'm really interested in this topic. However I can't figure out how to access those slides. Do you have to be enrolled?

[ Parent | on HN ]

Re:Improved vacuum in PostgreSQL 13 by kev009 on Tuesday May 12, 2020 @01:35PM (#23156893)

https://15721.courses.cs.cmu.edu/spring2020/schedule.html

[ Parent | on HN ]

Re:Improved vacuum in PostgreSQL 13 by jasonwatkinspdx on Tuesday May 12, 2020 @04:00PM (#23158980)

Yeah, he does two big database classes, and the last couple years of each are online with slides, youtube of the lectures, etc. Just click on the schedule for each class. They're amazing resources for learning the state of the art.

[ Parent | on HN ]