[Pgpool-general] Suggestion for load_balancing mode

[Josh Berkus]

Tatsuo,

> But subsequent SELECT to the temporay table will have problem since
> there's no gurantee that the SELECT always runs on the same server
> where the temporary table created, no?

Hmmm.  PgPool doesn't maintain any kind of session continuity?  Then how can 
we access temp tables at all?

> Right now you can get the same effect by using /*NO LOAD BALANCE*/.
>
> > /*LOADBALANCE*/ : rest of statement is load-balanced regardless of
> > contents

Ah, then that should be /*LOAD BALANCE*/


-- 
Josh Berkus
Aglio Database Solutions
San Francisco