[pgpool-general: 9084] Re: [External] Re: Suggestions on backend_clustering_mode

[Schewe, Jon P RTX]

> >> >
> >> >
> >> >
> >> >  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://urldefense.com/v3/__https://www.pgpool.net/mantisbt/view.php?id=822__;!!MvWE!CTb3FBX7-VcgvK_atVkQEy9RVa1EVtBY0wGG_j9mR1bb8IOtx45DCWUwYZ-wzjy3IHnbDIkpzEyOTNPiKw$
>
> I'm unable to view that issue. I created an account and when trying to navigate to it I was given the "Access denied" message.
>
> >>
> >> Another workaround is to configure PostgreSQL's synchronous replication to avoid replication delay.
>
> I'll look into this. How does the performance of this option compare with the snapshot isolation mode in pgpool?

I did a fair amount of reading on the snapshot isolation mode. It looks like this mode sends all commands to all backends and postgresql doesn't need to do any replication.
Am I reading that correctly?
If this has good performance this sounds like a simplier way to do the clustering.
What are the reasons that people don't use this by default?