Check database integrity takes days and backups stalled!

1

Hi,

my database ist around 150 gb and it always checks on frieday when all the backups starting. thats bad because all backups stall until check is finish!

  1. can the database be shrinked?
  2. how to move the check after the backups are finish?
  3. why is the database 150 gb in size? there any option for normalization?

Thank you!

2

For larger workloads:

  • Make sure the database does not get corrupted by using appropriate hardware (ECC RAM, good flash storage, …)
  • Perhaps put the database on storage that does integrity checking (Ceph, btrfs, ZFS, …)
  • Backup the database yourself – one option is to install the client on the server itself
  • Then disable the integrated “backup”