Re: multiple tables vs. partitions and TTL

2018-02-01 Thread Alain RODRIGUEZ
Hello Marcus, We want to store bigger amounts of data (> 30mio rows containing blobs) > This should be perfectly fine for a partition. We use to recommend up to 100 MB per partition, which is a soft limit, as some use cases work very well with bigger partition. will be deleted depending on the

Re: multiple tables vs. partitions and TTL

2018-02-01 Thread James Shaw
if me, I will go 1 table, just think too much labor to manage many tables and also how reliable while switching tables. Regarding tombstones, may try some ways to fight: reasonable partition size ( big partition with large tombstones will be a problem); don't query tombstones as possible, in

multiple tables vs. partitions and TTL

2018-02-01 Thread Marcus Haarmann
Hi experts, I have a design issue here: We want to store bigger amounts of data (> 30mio rows containing blobs) which will be deleted depending on the type of data on a monthly base (not in the same order as the data entered the system). Some data would survive for two month only, other