I use CLN with postgresql, which makes me have zero issues with channel database or compacting (CLN compacts on the fly).
After almost three months the database is at 16GB, which is extremely reasonable considering I have more than a thousand channels and more than 10,000 forwards a day (not to mention all the remotely failed forwards).