Re: Massively Parallel transactioning?

Joshua D. Drake <jd@commandprompt.com>

From: "Joshua D. Drake" <jd@commandprompt.com>
To: Benjamin Smith <lists@benjamindsmith.com>
Cc: pgsql-general@postgresql.org
Date: 2010-08-18T23:58:08Z
Lists: pgsql-general
On Wed, 2010-08-18 at 16:32 -0700, Benjamin Smith wrote:

> So far, it's been a dream, but now, as we continue to grow, we're starting to 
> reach connection limits per server. Short of raising the number of 
> simultaneous connections, is there a way to run all the transactions for a 
> single server for all databases within it on a single (or small number) of 
> connections? 

Well if you are just using it for updates to the schema etc... you
should only need to launch a single connection to each database to make
those changes.

Joshua D. Drake