Greg,
> In fact I think it's generally superior to having a layer like pgpool
> having to hand off all your database communication. Having to do an extra
> context switch to handle every database communication is crazy.
Although, one of their issues is that their database connection pooling is
per-server. Which means that a safety margin of pre-allocated connections
(something they need since they get bursts of 1000 new users in a few
seconds) has to be maintained per server, increasing the total number of
connections.
So a pooling system that allowed them to hold 100 free connections centrally
rather than 10 per server might be a win.
Better would be getting some of this stuff offloaded onto database replication
slaves.
--
--Josh
Josh Berkus
Aglio Database Solutions
San Francisco
