> >>>>> "TI" == Tatsuo Ishii <t-ishii@xxxxxxxxx> writes: > > TI> Yes, I thought about that too. Probably we need two kinds of > TI> initializations: > > TI> 1) initilization for each new connection (as you requested) > > TI> 2) initilization for each new client connection > > I think this latter one is important. Take the case where I do some > "set FOO BAR" values to alter the query (eg, statement timeout or > sequence scan disable) which should be reset on new client connection > when it re-uses a backend connection. > > Or is this magically handled already? Yes. pgpool issues "RESET ALL" at the end of each client connection. See "reset_query_list" directive. -- Tatsuo Ishii ---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings
