| From: | Steve Atkins <steve(at)blighty(dot)com> |
|---|---|
| To: | PostgreSQL List <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Massively Parallel transactioning? |
| Date: | 2010-08-18 23:43:01 |
| Message-ID: | 6A69AF22-6E88-4183-BA2A-49AB5983A082@blighty.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | ChronicDB Community Team | 2010-08-18 23:46:25 | Re: Massively Parallel transactioning? |
| Previous Message | Benjamin Smith | 2010-08-18 23:39:50 | Re: Clustering, parallelised operating system, super-computing |