Greetings, * Ron (ronljohnsonjr@xxxxxxxxx) wrote: > On 8/19/19 5:40 AM, Shiwangini Shishulkar wrote: > >We have scheduled postgres full backup on centos 7 machine. DB size is > >around 66 GB. We observed while backup is running, postmaster CPU % > >reaches to 90 - 100%,which results very strange behavior: that we are not > >able to perform any DDL and DML on to the database during the time. > >Please suggest a way to limit it's CPU utilization or else let us know how > >we can access the database during the backup window. Please let us know on > >priority since this is our prod database. > > Are you compressing the backup? > How many threads are you running? > How many CPUs on your system? > What version of Postgres? ... What are you using to run the backup? Thanks, Stephen
Attachment:
signature.asc
Description: PGP signature
