Postgres "asset" table 131GB

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.

Communities Docs About Terms Privacy

Postgres "asset" table 131GB - Immich

Postgres "asset" table 131GB

Similar Threads

Postgres "asset" table 131GB

Similar Threads

Similar Threads

Similar Threads