On 12/29/16 10:55 PM, Haribabu Kommi wrote: > Fujitsu was interested in developing a columnar storage extension with > minimal > changes the server backend. > > The columnar store is implemented as an extension using index access > methods. > This can be easily enhanced with pluggable storage methods once they are > available. > > A new index method (VCI) is added to create columnar index on the table.
I'm confused. You say that you are adding an index access method, for which we have a defined extension mechanism, but the code doesn't do that. Instead, it sprinkles a bunch of hooks through the table access code. So you are really adding ways to add alternatives to heap storage, except we have no way to know whether these hooks have been designed with any kind of generality in mind. So is it an index access method or a table access method? Either way, you shouldn't need a new relkind. Note that all indexes have the same relkind, even if they use different access methods. I think there are two ways to integrate column storage into PostgreSQL: One is to use the FDW interface. That has been done before, see cstore_fdw. The other is to define a storage manager extension interface. That has been tried but has not been completed yet. Adding a bunch of custom hooks all over the place seems worse than both of those. -- Peter Eisentraut http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services -- Sent via pgsql-hackers mailing list (email@example.com) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers