I have encountered a fairly strange behavior and am not sure if it is intended or a bug. What I am doing is quite simple. I do a “big”, about 1 MiB each, bulk UPSERT on one table with a completely identical dataset. Upsert acts as expected and does update all the columns appropriately and the final table also just contains that final data. The table however grows, and grows and grows. It is now 1GiB big, although the data it contains is just as small as 1 MiB.
The question is, does CockroachDB cleans this up at a later time, or is this just a bug?
Thanks in advance