Curious if you have better pointers to understand the fundamentals of the field?

If you have a common filter, it is a good idea to sort your data on that field and load into cstore_fdw. This will help to use skip indexes. https://github.com/citusdata/cstore_fdw#using-skip-indexes

This actually depends on your use case and type of your queries. There is a blog post (2014) about a benchmark: https://www.citusdata.com/blog/2014/06/14/columnar-store-ben...

I also believe that the main use case is for the compression of data more than the performance benefits.

Not baseball, but for the college football http://winningformula.espn.com/

Why not? It may be useful to people who already have their data in MongoDB and don't want to migrate their data to an RDBMS.

Migrating data can be automatic: https://github.com/crowdtap/promiscuous/

We use this tool to replicate data across our main MongoDB database, and a PostgreSQL one (eventually consistent).

We haven't wrote a comprehensive readme yet. The only documentation we have so far are slides: http://viennot.biz/promiscuous

Stay tuned :)

Those slides gave me a headache, so I'll just point out for the benefit of everyone that there is a README, and that it's some form of replication via AMQP queues.

Thanks for the tip on AMQP.

Even though I locked it, my bicycle also was stolen in Barcelona in 15 minutes in middle of city.