search

citusdata / cstore_fdw

Columnar storage extension for Postgres built as a foreign data wrapper. Check out https://github.com/citusdata/citus for a modernized columnar storage implementation built as a table access method.
Apache License 2.0
1.76k stars 171 forks source link

New cstore_fdw releases #171

Open gabitoju opened 6 years ago

gabitoju commented 6 years ago

Hi everyone. There hasn't been a release of cstore_fdw for a while now. Is there a road map of new features or a release planed for the short term?

Thanks

mtuncer commented 6 years ago

we haven't been very active lately. use now postgres internal storage is checked into develop branch. This change enables streaming replication on cstore_fdw tables.

There are some pending task to address transaction support and backward compatibility. We would be releasing cstore_fdw 2.0 after addressing them.

Is there a particular feature you would be interested in ?

gabitoju commented 6 years ago

Hey @mtuncer, thanks for the reply.

I think this https://github.com/citusdata/cstore_fdw/issues/168, different compression methods would be a good feature to have. Also, query table expressions like ROLLUP, GROUPING SETS and CUBE are a bit slow in cstore_fdw so it would be nice if it could work better with that sort of expressions or resolve a greater part of the query, not just the look up.

Thanks!

Hengjie commented 6 years ago

Yeah, agree with above. I'd love to have pushdown support of sum, count, group bys support so it doesn't do the aggregations at the pg level.