Request a Demo
Home   >   mailing lists

Re: Commit with wait event on advisory lock! - Mailing list pgsql-admin

From Tom Lane
Subject Re: Commit with wait event on advisory lock!
Date
Msg-id 3938129.1737566668@sss.pgh.pa.us
Whole thread Raw
In response to RE: Commit with wait event on advisory lock!  (<msalais@msym.fr>)
Responses RE: Commit with wait event on advisory lock!
List pgsql-admin
Tree view 
<msalais@msym.fr> writes:
> - Replication is used (2 standby, one sync and the other potential) but no
> application connection to replica.

Maybe you have synchronous_commit set to enforce waiting for the
standby to receive/apply the transaction?  If so I'd look for
possible delays there.

            regards, tom lane

pgsql-admin by date:

Previous
From:
Date:
Subject: RE: Commit with wait event on advisory lock!
Next
From:
Date:
Subject: RE: Commit with wait event on advisory lock!