3 ms·
I had that problem a couple versions ago.. turns out one table in the postgres DB, I think 'devices..' something got be like 50 GB and I could never get it widd
by stevenicr 2y ago
I had that problem a couple versions ago.. turns out one table in the postgres DB, I think 'devices..' something got be like 50 GB and I could never get it widdled down even with manual vacuums and such,
I think the newer version of matrix handles cleaning that table better, but I'd need to login a check, it's been a while.
Given that the DB gets so big I had to bit the bullet and move from spinning HDs to SSDs on my latest install. Make a big difference at the beginning of course, the DB had not ballooned yet.