Re: Massively Parallel transactioning?

Lists <lists@benjamindsmith.com>

From: Benjamin Smith <lists@benjamindsmith.com>
To: pgsql-general@postgresql.org
Date: 2010-08-19T18:19:16Z
Lists: pgsql-general
On Wednesday, August 18, 2010 04:58:08 pm Joshua D. Drake wrote:
> 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.

And that's exactly the problem. On each server, we have at least dozens of 
active databases - one for each client. Opening a connection for each database 
starts to become problematic. 

This problem is now solved with prepared transactions. 

-- 
This message has been scanned for viruses and
dangerous content by MailScanner, and is
believed to be clean.