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 -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers