Re: postmaster utilization - Mailing list pgsql-general

From Ron
Subject Re: postmaster utilization
Date
Msg-id 1580b264-7d47-a741-6acc-3f1ea8ee0d1f@gmail.com
Whole thread Raw
In response to postmaster utilization  (Shiwangini Shishulkar <shiwangini.shishulkar@webgility.com>)
Responses Re: postmaster utilization  (Stephen Frost <sfrost@snowman.net>)
List pgsql-general
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.



pgsql-general by date:

Previous
From: Shiwangini Shishulkar
Date:
Subject: postmaster utilization
Next
From: Magnus Hagander
Date:
Subject: Re: pg_basebackup exit codes