Is the project still alive?

[Juan Emilio Gabito Decuadra]

I haven't seen many activity in github so I wonder if the project is still alive. Is there a calendar of releases or something like that?

[Murat Tuncer]

Hello

Project is still alive, but in somewhat slow motion. We haven't been able to allocate much time recently.

Speaking of calendar, I can't give an exact timing, but I think we would have a new release sometime in early summer.

Murat

On Tue, Feb 27, 2018 at 8:24 PM, Juan Emilio Gabito Decuadra <gabi...@gmail.com> wrote:

I haven't seen many activity in github so I wonder if the project is still alive. Is there a calendar of releases or something like that?

--
You received this message because you are subscribed to the Google Groups "cstore users" group.
To unsubscribe from this group and stop receiving emails from it, send an email to cstore-users+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

--

Murat Tuncer
Software Engineer | Citus Data
mtu...@citusdata.com

[David Woodstuck]

I am looking for Column-based DBMS. I am evaluating ClickHouse. I am wondering how to compare ClickHouse to cstore in Postgresql. Is Cstore in postgres free? Is is stable for production as well as its performance for big data query?

Thanks,

David

On Wednesday, February 28, 2018 at 3:07:35 PM UTC+8, Murat Tuncer wrote:

Hello

Project is still alive, but in somewhat slow motion. We haven't been able to allocate much time recently.

Speaking of calendar, I can't give an exact timing, but I think we would have a new release sometime in early summer.

Murat

On Tue, Feb 27, 2018 at 8:24 PM, Juan Emilio Gabito Decuadra <gabi...@gmail.com> wrote:

I haven't seen many activity in github so I wonder if the project is still alive. Is there a calendar of releases or something like that?

--
You received this message because you are subscribed to the Google Groups "cstore users" group.

To unsubscribe from this group and stop receiving emails from it, send an email to cstore-users...@googlegroups.com.

For more options, visit https://groups.google.com/d/optout.

[Balazs Gunics]

Hello David,

Based on my experience, It's production capable.

Our production DB has about 6-7 terabytes of data stored in cstore. Our compression ratio is around 5-8 times.(Oppose to the 3 times mentioned on the site.)

The raw data is is somewhere between 30-50 terabytes.

When we hit performance issues (cstore table size was 30GB or more) we could use partitioning on the tables, because skip indexes on text fields are not working as expected. (On numbers / dates it works perfectly.)

I think that aspect could be improved. Currently we just create partitions for these fields. (They contain values like JAN-16, FEB-17, MAR-18 , etc...)

Keep in mind that pg_dump will NOT work. We have used \COPY to create files that can be used as backups.

But I think this will be fixed in a newer version of cstore.

Hope this helped.

To unsubscribe from this group and stop receiving emails from it, send an email to cstore-users+unsubscribe@googlegroups.com.

For more options, visit https://groups.google.com/d/optout.

--

Balázs Gunics

Product Manager - ETL specialist - Starschema Ltd.
Mobile: +36 30 657 4744
Email:  gun...@starschema.net    Web: www.starschema.net

[Juan Emilio Gabito Decuadra]

Hello Balázs,

Do you use cstore in combination with citus?

What about table config? You create the tables with the default values or do you change de stripe and block size?

Any other advice for table modeling?

Thanks!