Hi All, Let's imagine that I have the following schema:
CREATE TABLE IF NOT EXISTS history_data ( discriminator uuid, a bigint, b bigint, date date, data custom_type, PRIMARY KEY ((discriminator, a, b), date) ) WITH CLUSTERING ORDER BY (date DESC); I want to delete the data from this table for a single pair (a and b) and multiple dates: DELETE FROM history_data WHERE discriminator = ... and a = 1 and b = 4 and date in (:list_of_dates) How many dates can I pass in a single delete query without any performance issues? I planned to split the list_of_dates into multiple buckets and then send an unlogged batch with all delete queries. Thanks, Uladzimir