> I guess the disconnected client won't be happy about that :) pgPool is > really usefull when you have lots of small sessions. If you only have > some long connections, then pgpool pooling mode won't be of any use. > Perhaps the other modes, but not the pooling one. And in this case, you > should better look at pgBouncer and its transaction or query pooling > mode.
Thanks Guillaume. It looks like pgBouncer's transaction pooling is actually what we need since our app persists connections but is idle most of the time. Let me check that out. Unfortunately, it does not seem to have the same feature set as pgpool. So, down the road, when we want to do some of the other things, we will have decide between the two. johnny _______________________________________________ Pgpool-general mailing list [email protected] http://pgfoundry.org/mailman/listinfo/pgpool-general
