Re: postmaster utilization

2019-08-20 Thread Stephen Frost
Greetings, * Kyotaro Horiguchi (horikyota@gmail.com) wrote: > At Mon, 19 Aug 2019 10:07:30 -0400, Stephen Frost wrote > in <20190819140730.gh16...@tamriel.snowman.net> > > * Ron (ronljohnso...@gmail.com) wrote: > > > On 8/19/19 5:40 AM, Shiwangini Shishulkar wrote: > > > >We have scheduled p

Re: postmaster utilization

2019-08-19 Thread Kyotaro Horiguchi
At Mon, 19 Aug 2019 10:07:30 -0400, Stephen Frost wrote in <20190819140730.gh16...@tamriel.snowman.net> > Greetings, > > * Ron (ronljohnso...@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 > > >ar

Re: postmaster utilization

2019-08-19 Thread Stephen Frost
Greetings, * Ron (ronljohnso...@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 b

Re: postmaster utilization

2019-08-19 Thread Ron
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

postmaster utilization

2019-08-19 Thread Shiwangini Shishulkar
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 sugges