Re:PostgreSQL Columnar Store for Analytic Workloads
by jasonmp85 on Thursday April 03, 2014 @01:46PM
(#7524606)
(I'm Jason from Citus Data)
As Ozgun notes above, the Foreign Data Wrapper APIs just provide a powerful abstraction for what this extension is doing.
Though the DDL to set up a foreign table requires first creating a "server" with CREATE SERVER, this is merely a formality: as in file_fdw the server doesn't actually represent an external process. All I/O occurs within the postgres backend process servicing the query.
Similar to how Infobright is just MySQL but you still can't mix columnar and regular DBs in the same instance, you have to run IB separately.