From: Divakar Singh <dpsmails@yahoo.com>
To: pgsql-performance@postgresql.org
Subject: Which gives good performance? separate database vs separate schema
Date: Thu, 25 Nov 2010 03:37:36 -0800 (PST)
Message-ID: <991565.83793.qm@web65414.mail.ac4.yahoo.com> (raw)
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: dpsmails@yahoo.com
Subject: Re: Which gives good performance? separate database vs separate schema
In-Reply-To: <991565.83793.qm@web65414.mail.ac4.yahoo.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox