Skip site navigation (1) Skip section navigation (2)

Re: Multiple data base on same server

From: "elias ghanem" <e(dot)ghanem(at)acteos(dot)com>
To: "'Richard Huxton'" <dev(at)archonet(dot)com>
Cc: <pgsql-performance(at)postgresql(dot)org>
Subject: Re: Multiple data base on same server
Date: 2010-02-26 12:45:50
Message-ID: 201002261242.o1QCgoka009150@relay-ext.ornis.com (view raw or flat)
Thread:
Lists: pgsql-performance
Hi,
Thanks for your answer,
Concerning the second point, each db have different table that are logically
related (for ex, tables for configuration, tables for business...) plus I'm
planning to put the indexes on their own tablespaces.
Concerning the disks I will maybe stored on multiple disks (but surely not
200-300). So I'm just wondering If this big number of tablespaces on a same
db server may cause problems,
Thanks again.

-----Original Message-----
From: pgsql-performance-owner(at)postgresql(dot)org
[mailto:pgsql-performance-owner(at)postgresql(dot)org] On Behalf Of Richard Huxton
Sent: Friday, February 26, 2010 1:44 PM
To: elias ghanem
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: [PERFORM] Multiple data base on same server

On 26/02/10 09:37, elias ghanem wrote:
> Hi,
>
> I'm using postgresql 8.4
>
> I need to install multiple postgresql dbs on one server but I have some
> questions:
>
> -Is there any problems (performance wise or other) if I have 10 to 15 DBs
on
> the same server?

Clearly that's going to depend on what they're all doing and how big a 
server you have. There's no limitation in PostgreSQL that stops you though.

> -Each DB needs 10 tablespaces, so if I create 10 different tablespaces for
> each DB I will have 100 to 150 table space on the same server. So can this
> also cause any problems?

Do you have 200-300+ disks to put these tablespaces on? If not, I'm not 
clear what you are trying to do. Why does each DB need 10 tablespaces?

-- 
   Richard Huxton
   Archonet Ltd

In response to

Responses

pgsql-performance by date

Next:From: Richard HuxtonDate: 2010-02-26 13:03:33
Subject: Re: Multiple data base on same server
Previous:From: Richard HuxtonDate: 2010-02-26 11:44:09
Subject: Re: Multiple data base on same server

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group