Commit Delay - Mailing list pgsql-admin

From Naveen Sankineni
Subject Commit Delay
Date
Msg-id CAOOQyJKp-zPNCPLvYoL+GES22iRv8uXLK3Jh7FsvoH2MDK9rBQ@mail.gmail.com
Whole thread Raw
Responses Re: Commit Delay  (Bruce Momjian <bruce@momjian.us>)
List pgsql-admin
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


Thanks,
Naveen.

pgsql-admin by date:

Previous
From: "Radoulov, Dimitre"
Date:
Subject: Re: Performance Reports
Next
From: Bruce Momjian
Date:
Subject: Re: Commit Delay