Re:PostgreSQL columnar store benchmarks on SSDs
by klreierson on Wednesday June 04, 2014 @08:11PM
(#7849310)
Do the benchmarks for postgres utilize in memory columar store (IMCS)? What is the difference between postgres imcs and citus cstore_fdw? http://www.postgresql.org/message-id/52C59858.9090500@garret...
[ Parent
| on HN ]
Re:PostgreSQL columnar store benchmarks on SSDs
by bredman on Thursday June 05, 2014 @12:41PM
(#7852754)
The benchmarks use cstore_fdw which is a columnar store that is accessed via the PostgreSQL foreign data wrapper system.
ICMS is a different implementation of a columnar store for PostgreSQL. I don't know it extremely well but my understanding is that it uses the PostgreSQL shared memory system to allocate memory for a columnar store. This columnar store is not queried via standard SQL commands but rather using a combination of a custom query language and some user defined functions.