3 ms·
The discussion is moving on lately with a refactoring to create an access method handler for tables: https://www.postgresql.org/message-id/d7e41e76-e565-8bc0-4e
by ioltas 10y ago
The discussion is moving on lately with a refactoring to create an access method handler for tables:
https://www.postgresql.org/message-id/d7e41e76-e565-8bc0-4e97-bd3d127a7507@postgrespro.ru https://www.postgresql.org/message-id/d7e41e76-e565-8bc0-4e9...
Here is as well some documentation on the matter:
https://wiki.postgresql.org/wiki/HeapamRefactoring https://wiki.postgresql.org/wiki/HeapamRefactoring
Having "CREATE ACCESS METHOD [...] ON STORAGE|TABLE" to create a custom access method, or storage engine, and extending CREATE TABLE to be able to pass a storage method with the table definition could become a quite powerful combination. The main challenge is to come up with an interface solid enough to be able to handle problems related to MVCC, like VACUUM cleanup.