[Pgpool-general] Suggestion for load_balancing mode

[Tatsuo Ishii]

> > 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?

What you are willing is a "session level load balancing". pgpool only
implements "statement level load balancing". I will add the "session
level load balancing" to my TODO list.

> > 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*/

I see.

BTW, why you don't use Slony-I for replicatin?
--
Tatsuo Ishii