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