News for hackers. Stuff that matters.

A comment on PostgreSQL columnar store benchmarks on SSDs. Parent comment

Re:PostgreSQL columnar store benchmarks on SSDs by techscruggs on Wednesday June 04, 2014 @02:17PM (#7847201)
Its a bad solution for OLTP. C-stores are read optimized while a typical (row-oriented) rdbms is write optimized. Read optimized storage is typically accomplished via a write buffer that is flushed to a read store at a certain epoch.

Basically, if you need to be able to immediately read the data you just wrote, a cstore is a bad choice.

[ Parent | on HN ]
Re:PostgreSQL columnar store benchmarks on SSDs by ironchef on Wednesday June 04, 2014 @02:50PM (#7847379)
There's also in betweens. Cassandra for example is a bit of a hybrid. It writes quite well even though it has some columnar / big-table aspects.
[ Parent | on HN ]