Re: Massively Parallel transactioning? - Mailing list pgsql-general

From Steve Atkins
Subject Re: Massively Parallel transactioning?
Date
Msg-id 6A69AF22-6E88-4183-BA2A-49AB5983A082@blighty.com
Whole thread Raw
In response to Massively Parallel transactioning?  (Benjamin Smith <lists@benjamindsmith.com>)
List pgsql-general
On Aug 18, 2010, at 4:32 PM, Benjamin Smith wrote:

> Is there a way to update a number of databases hosted on a single server
> without opening a separate psql connection to each database?
>
> We have a cluster of servers hosting an application on Postgres. Right now, we
> have dozens of databases per server, enough that we're starting to have
> problems with our update process.
>

Any reason you're using multiple databases, rather than multiple schemas?

> Is there a better way?

Schemas, probably. Though lazy schema updates done by the application might help too.

Cheers,
  Steve


pgsql-general by date:

Previous
From: Benjamin Smith
Date:
Subject: Re: Clustering, parallelised operating system, super-computing
Next
From: ChronicDB Community Team
Date:
Subject: Re: Massively Parallel transactioning?