My database is currently at 23GB. Although I configured it to retain only the last 10 backups and saved the changes, the database size remains at 23GB.
Is it possible to use another database alongside PostgreSQL? Also, I’m curious about the 23GB size—despite setting it to retain only the last 10 backups, it hasn’t decreased. Any insights on why this might be happening?
Just to cover a probably unlikely case, saving the setting is just doing that. You must run a backup too, which would delete the versions, so likely take a long time compacting, but DB shrink needs a vacuum
Usage: vacuum <storage-URL> [<options>]
Rebuilds the local database, repacking it into a minimal amount of disk space.
VACUUM (SQLite docs, and note their discussion about needing a lot of temporary space to do this).