On Tue, Feb 18, 2025 at 7:17 AM Abdullah Ergin <abdullaherginwork@xxxxxxxxx> wrote:
Hi,
I have a 9.3 TB database. And when I take a full backup, the space it occupies in the repo is 8.7 TB. This compression is not enough for me. It needs to be compressed more, I did not enter any parameters on my backup server for compression, so it compresses with default parameters (gz). Normally gz compresses well, why is there so little compression?
Is your data very compressible?
Are you sure the backups are being compressed?
Also my archive files, the two days archive file of my stanza is now 744GB. I understand that my old archive files are not deleted after my incr backup. Wouldn't my old archive files be redundant after my incremental backups, wouldn't it be better to delete them?
Not if you ever need to restore to a PIT somewhere in the middle of the day.
And there's always open transactions which might be open when you start pgbackrest.
What is the parameter to ensure deletion?
There isn't one, since it's a bad idea.
Death to <Redacted>, and butter sauce.
Don't boil me, I'm still alive.
<Redacted> lobster!
