Which gives good performance? separate database vs separate schema

From: Divakar Singh <dpsmails(at)yahoo(dot)com>
To: pgsql-performance(at)postgresql(dot)org
Subject: Which gives good performance? separate database vs separate schema
Date: 2010-11-25 11:37:36
Message-ID: 991565.83793.qm@web65414.mail.ac4.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Hello Friends,
I have many instances of my software running on a server (Solaris SPARC). Each
software instance requires some DB tables (same DDL for all instances' tables)
to store data.
It essentially means that some processes from each instance of the software
connect to these tables.
Now, should I put these tables in 1 Database's different schemas or in separate
databases itself for good performance?
I am using libpq for connection.

Pictorial Representation:

Process1 -> DB1.schema1.table1

Process2 -> DB1.schema2.table1

Vs.

Process1 -> DB1.default.table1

Process2 -> DB2.default.table1

Which one is better?

thanks in advance

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message tv 2010-11-25 12:02:08 Re: Which gives good performance? separate database vs separate schema
Previous Message Markus Schulz 2010-11-24 18:37:07 problem with from_collapse_limit and joined views