Re: [PERFORM] Multiple data base on same server

2010-02-26 Thread Ing. Marcos Ortiz Valmaseda
elias ghanem escribió: 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? -Each DB needs 10 tablespaces, so if I create 10 different

Re: [PERFORM] Multiple data base on same server

2010-02-26 Thread elias ghanem
Ok thanks guys for your time -Original Message- From: Craig James [mailto:craig_ja...@emolecules.com] Sent: Friday, February 26, 2010 4:34 PM To: Richard Huxton Cc: elias ghanem; pgsql-performance@postgresql.org Subject: Re: [PERFORM] Multiple data base on same server Richard Huxton

Re: [PERFORM] Multiple data base on same server

2010-02-26 Thread Craig James
Richard Huxton wrote: On 26/02/10 12:45, elias ghanem wrote: 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 tablespace

Re: [PERFORM] Multiple data base on same server

2010-02-26 Thread elias ghanem
nt: Friday, February 26, 2010 1:44 PM To: elias ghanem Cc: pgsql-performance@postgresql.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 serv

Re: [PERFORM] Multiple data base on same server

2010-02-26 Thread Richard Huxton
On 26/02/10 12:45, elias ghanem wrote: 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

Re: [PERFORM] Multiple data base on same server

2010-02-26 Thread Richard Huxton
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

[PERFORM] Multiple data base on same server

2010-02-26 Thread elias ghanem
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? -Each DB needs 10 tablespaces, so if I create 10 different tablespaces for each DB I will