Greetings,
* Ron (ronljohnsonjr@gmail.com) 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