zlacker

[parent] [thread] 4 comments
1. no_wiz+(OP)[view] [source] 2023-04-26 18:21:42
Can the MVCC implementation be swapped via Postgres extensions?
replies(3): >>apavlo+x1 >>BohanO+Y1 >>rch+H5
2. apavlo+x1[view] [source] 2023-04-26 18:29:55
>>no_wiz+(OP)
No. It would be a major surgery on the internals. See the article for my comment at the attempt to do this with the Zheap project:

https://wiki.postgresql.org/wiki/Zheap

replies(1): >>jabl+Ux1
3. BohanO+Y1[view] [source] 2023-04-26 18:31:56
>>no_wiz+(OP)
I think there is a new project from the Postgres community. They try to replace the storage engine to solve the inefficiency caused by MVCC

https://github.com/orioledb/orioledb

4. rch+H5[view] [source] 2023-04-26 18:50:47
>>no_wiz+(OP)
Depending on the use case, I'd consider a foreign data wrapper.
◧◩
5. jabl+Ux1[view] [source] [discussion] 2023-04-27 06:09:07
>>apavlo+x1
Shame that zheap seems to have fizzled out. Do you think there's any prospect of it being resurrected and eventually mainlined?
[go to top]