There is an extension that removes the need to lock tables to repack / vaccum. Figure out how it works! #20

chotchki · 2021-08-21T18:56:13Z

https://github.com/reorg/pg_repack
Investigate if the zheap table format would be better to implement.
Until I get past a WAL implementation and planner costs I don't think its worth it.
- Since I extended the size of transaction IDs, I probably have a larger issue on my hands than normal postgres.
- - Reading into the zheap approach I'm thinking that I might have some space saving options availible for me. In particular if a tuple is frozen so its always availible I could remove the xmin/xmax and pack more into the page. Need more thinking however my approach of questioning the storage efficency of each part of data seems to be worth it.

chotchki added this to Backlog in FeOphant Post MVP Aug 22, 2021

Provide feedback