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
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
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