[pgpool-general: 9079] Re: Suggestions on backend_clustering_mode

[Bo Peng]

Hi,

I have 3 backends, I'm currently using the default streaming_replication. I
> have run into some issues with Atlassian's Jira where they claim that the
> offloading of read queries and the delays in replication are causing
> issues. Their suggestion is to switch to snapshot_isolation. I have done a
> little bit of reading on this and snapshot_isolation appears to have some
> issues of it's own as well. What are others using for
> backend_clustering_mode and why?
>

I think it is a simimar issue with  this issue:
https://www.pgpool.net/mantisbt/view.php?id=822

Another workaround is to configure PostgreSQL's synchronous replication to
avoid replication delay.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.pgpool.net/pipermail/pgpool-general/attachments/20240409/c386335f/attachment.htm>