[pgpool-general: 6109] Re: target_session_attrs
Christophe Pettus
xof at thebuild.com
Wed May 30 11:57:39 JST 2018
> On May 29, 2018, at 17:24, Mario V <mariovikale at hotmail.com> wrote:
>
> How does pgpool compare with the new v10 feature target_session_attrs
> for routing writes to the primary and reads to the standby?
They're very different. target_session_attrs is only at time of connection, in which it will pick one server (from a list) with a particular set of attributes. Once that connection is established, it doesn't change unless you close and reopen the connection. Thus, if you open the connection asking for a server that can take writes, you get the master, and all queries sent down that connection go to the master. There's no equivalent of pgpool2's per-query routing.
--
-- Christophe Pettus
xof at thebuild.com
More information about the pgpool-general
mailing list