Commit Delay

From: Naveen Sankineni <nsankineni(at)gmail(dot)com>
To: pgsql-admin(at)lists(dot)postgresql(dot)org
Subject: Commit Delay
Date: 2020-04-30 23:31:01
Message-ID: CAOOQyJKp-zPNCPLvYoL+GES22iRv8uXLK3Jh7FsvoH2MDK9rBQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Bruce Momjian 2020-04-30 23:33:54 Re: Commit Delay
Previous Message Radoulov, Dimitre 2020-04-30 12:08:28 Re: Performance Reports