On 8/19/19 5:40 AM, Shiwangini Shishulkar wrote:
Hi,
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?
--
Angular momentum makes the world go 'round.
