Zheap: Reinvented PostgreSQL Storage

Posted by gbrown_ on Wednesday October 07, 2020 @01:49PM
from the cybertec-postgresql.com dept.

https://www.cybertec-postgresql.com/en/zheap-reinvented-postgresql-storage/

( 5 comments | 45 points | on HN )

Re:Zheap: Reinvented PostgreSQL Storage by bithavoc on Wednesday October 07, 2020 @06:53PM (#24713747)

The cookie popup in this website is just horrible. I can’t close it, I can’t read the article.

[ Parent | on HN ]

Re:Zheap: Reinvented PostgreSQL Storage by hrishios on Thursday October 08, 2020 @10:04AM (#24719170)

Same problem - and it's a shame, the article seems well written and decently insightful - still couldn't finish it.

[ Parent | on HN ]

Re:Zheap: Reinvented PostgreSQL Storage by Tostino on Wednesday October 07, 2020 @05:51PM (#24713171)

I was just wondering what the status of this was. Anyone know if EDB is still working on it? Is just cybertec working on a fork of it now?

This was something I have been looking forward to for quite some time, but the discussion kinda died off in the mailing list.

[ Parent | on HN ]

Re:Zheap: Reinvented PostgreSQL Storage by tmd83 on Thursday October 08, 2020 @12:16PM (#24720555)

I'm not a real expert, but is this design very similar to Oracle database storage engine? I think they also use logs for undo and page level transaction locks and such if I'm not mistaken.

[ Parent | on HN ]

Re:Zheap: Reinvented PostgreSQL Storage by atombender on Thursday October 08, 2020 @01:43PM (#24721649)

Yes, it's similar to the in-place row update system used by not just Oracle, but also Microsoft SQL Sercer and probably other databases.

[ Parent | on HN ]