From: Thomas Kellerer <spam_eater@gmx.net>
To: pgsql-performance@postgresql.org
Subject: Re: Which gives good performance? separate database vs separate schema
Date: Thu, 25 Nov 2010 13:03:29 +0100
Message-ID: <icljah$8pe$1@dough.gmane.org> (raw)
In-Reply-To: <991565.83793.qm@web65414.mail.ac4.yahoo.com>
References: <991565.83793.qm@web65414.mail.ac4.yahoo.com>
Divakar Singh, 25.11.2010 12:37:
> 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.
>
I don't think it will make a big difference in performance.
The real question is: do you need queries that "cross boundaries"? If that is the case you have to use schema, because Postgres does not support cross-database queries.
Regards
Thomas
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: spam_eater@gmx.net
Subject: Re: Which gives good performance? separate database vs separate schema
In-Reply-To: <icljah$8pe$1@dough.gmane.org>
* 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