OPTIMIZE TABLE table_name WITH (only_expunge_deletes = true) seems like never ending

CrateDB
1

Hello,

I have a table in cratedb which had almost 360 million records. I deleted 100 million records from the table but size of the table did not decreased. I started the query OPTIMIZE TABLE table_name
WITH (only_expunge_deletes = true) last night query did not finished and also the size of the table is still increasing very fast. It was 2.1 T in size yesterday after I deleted the documents and executed optimize it is 2.7 T right now. quite hard to understand why it is increasing constantly without writing the data. I also tried to kill optimize query since it is not deleting anything and increasing the size of the table. It is not killable also .

2

To be more precise this is the information of the table segments table right now has:

SELECT
SUM(deleted_docs) AS total_deleted_docs
FROM
sys.segments
WHERE
table_name = ‘table_name’ limit 100; → this returns 229234152

select count(*) from sys.segments where table_name = ‘table_name’ limit 100; → this returns 1131