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

[chotchki]

• 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.