Postgres Database Backup Size

2019-08-11 Thread Shiwangini Shishulkar
Hi, Here , we have first tried with .BAK backups. For, 43GB database-> the backup size was ~86GB. Then, I configured backup with .sql file. Here it was ~70GB for the same database size. Next, now our database size keeps increasing. As well as backup size is also increasing. Now, backup size is

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