On Thu, Apr 30, 2020 at 07:31:01PM -0400, Naveen Sankineni wrote: > Hello , > > I would need your advice on which parameter is least impacted in terms of Data > Loss if we wanted to set . > One of our Database is waiting on I/O when there is a batch operation that runs > to Insert/Delete table data is impacting the small updates that runs on a > continuous basis where it shows that wait is on walwritelock. > > commit_delay > synchronous_commit The full list is here: https://www.postgresql.org/docs/12/non-durability.html I would say synchronous_commit. -- Bruce Momjian <bruce@xxxxxxxxxx> https://momjian.us EnterpriseDB https://enterprisedb.com + As you are, so once was I. As I am, so you will be. + + Ancient Roman grave inscription +
