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.