Re: postmaster utilization
| От | Ron |
|---|---|
| Тема | Re: postmaster utilization |
| Дата | |
| Msg-id | 1580b264-7d47-a741-6acc-3f1ea8ee0d1f@gmail.com обсуждение исходный текст |
| Ответ на | postmaster utilization (Shiwangini Shishulkar <shiwangini.shishulkar@webgility.com>) |
| Ответы |
Re: postmaster utilization
|
| Список | 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 по дате отправления: