Hello all, I have a column family where I have to update a field frequency, but it is a clustering key. So I am deleting the existing row and adding a new row again with updated frequency.
I want to free the space used for deleted rows as soon as possible, so I decided to change gc_grace_seconds value to a smaller value than default. For that I used following query in cqlsh. *alter table corpus.word_inv_pos_frequency with GC_GRACE_SECONDS = 3600;* Is this enough to free space after one hour? Do I have to do anything else? Also how can I check the gc_grace value of a column family using cqlsh or cassandra-cli? Thank You! -- *Chamila Dilshan Wijayarathna,* SMIEEE, SMIESL, Undergraduate, Department of Computer Science and Engineering, University of Moratuwa.
