Because this is a topic that interests me I have done some digging.
MonetDB is a proper column-store DBMS. It is used on some decent sized projects, several of which are EU-funded.
Digging a bit deeper I have discovered that a PostgreSQL Foreign Data Wrapper for MonetDB has been created - monetdb_fdw.
The fdw is written up
here There is a video that shows what happens when a query is executed in PostgreSQL and MonetDB
The video shows an analytical query being processed
- Using PostgreSQL - 177 seconds
- Using MonetDB - 8 seconds
- Using a remote MonetDB server through MonetDB FDW - 1 second
I think its worth investigating further
Robin St.Clair
