On 03/23/2011 12:52 PM, Robert Haas wrote:
> Yes. What this won't do is let you build a big load-balancing network
> (at least not without great caution about what you assume).
This sounds too strong to me. Session-aware load balancing is pretty
common these days. It's the default mode of PgBouncer, for example.
Not much caution required there, IMO. Or what pitfalls did you have in
mind?
> What it
> will do is make it really, really hard to lose committed transactions.
> Both good things, but different.
..you can still get both at the same time. At least as long as you are
happy with session-aware load balancing. And who really needs finer
grained balancing?
(Note that no matter how fine-grained you balance, you are still bound
to a (single core of a) single node. That changes with distributed
querying, and things really start to get interesting there... but we are
far from that, yet).
Regards
Markus