I just noticed that my postgres database (only used for immich) is fairly large, after investigating a bit I've pinned it down to the
asset
asset
table having a table size of 98GB and index size of 33GB. all the other tables are negligable. Does anyone know why that table got so large? I don't have a lot of assets, Immich server stats report a total storage space of 77GiB.