Received: from maia.hub.org (maia-3.hub.org [200.46.204.243])
	by mail.postgresql.org (Postfix) with ESMTP id DAEDD1337B34
	for <pgsql-performance-postgresql.org@mail.postgresql.org>;
	Thu, 25 Nov 2010 07:37:44 -0400 (AST)
Received: from mail.postgresql.org ([200.46.204.86])
	by maia.hub.org (mx1.hub.org [200.46.204.243]) (amavisd-maia,
	port 10024) with ESMTP id 71968-05
	for <pgsql-performance-postgresql.org@mail.postgresql.org>;
	Thu, 25 Nov 2010 11:37:37 +0000 (UTC)
X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6
Received: from nm28-vm0.bullet.mail.ac4.yahoo.com
	(nm28-vm0.bullet.mail.ac4.yahoo.com [98.139.52.246])
	by mail.postgresql.org (Postfix) with SMTP id 4BB8E1336971
	for <pgsql-performance@postgresql.org>;
	Thu, 25 Nov 2010 07:37:37 -0400 (AST)
Received: from [98.139.52.192] by nm28.bullet.mail.ac4.yahoo.com with NNFMP;
	25 Nov 2010 11:37:37 -0000
Received: from [98.139.52.176] by tm5.bullet.mail.ac4.yahoo.com with NNFMP;
	25 Nov 2010 11:37:37 -0000
Received: from [127.0.0.1] by omp1059.mail.ac4.yahoo.com with NNFMP;
	25 Nov 2010 11:37:37 -0000
X-Yahoo-Newman-Property: ymail-3
X-Yahoo-Newman-Id: 221304.90207.bm@omp1059.mail.ac4.yahoo.com
Received: (qmail 83932 invoked by uid 60001); 25 Nov 2010 11:37:37 -0000
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.com; s=s1024;
	t=1290685056; bh=Xas81hqNGI1hddPRmCuL2iA439iBwJuWcStYk0a36Gg=;
	h=Message-ID:X-YMail-OSG:Received:X-Mailer:Date:From:Subject:To:MIME-Version:Content-Type;
	b=134DDyve5OnXtzO7jrfI9WZjZsfCI+v3YfVB+tlAd1/2S6C5QtFxpatEVfx4dUd2XB+ZCKgODsGfUEqq6QYYQeFHBQQIlY9ONIsZisz2kuzNj+K9EcWIszy5XbTsmZenoM+VefxcKZxqehWyk1vrcajKkpEYfjE/l8znO3kTV9w=
DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com;
	h=Message-ID:X-YMail-OSG:Received:X-Mailer:Date:From:Subject:To:MIME-Version:Content-Type;
	b=jjGkCPS1cDvDGVAXzKu9q5pzhAR0wtd8mNyfaDln+FCW4iZx/xgVScGefqrY0UW+GQ3U3VxVQg+L5c/XSydBZB6ZZP38cFL/oKGZnD33Q1D8wLnP3TmILxK4Ib9xAOTwM0/ZyVQ22A8XMN8FQk9io9psr24BT3GSpD40z5fiah0=;
Message-ID: <991565.83793.qm@web65414.mail.ac4.yahoo.com>
X-YMail-OSG: Luyt6UkVM1l9jRT_N4HeSeRbBNOBixARiMiS1XoI6.WSlXJ
	shSugHv6R.05X59PQMnA6eEKKJ.apubX8gMyTUCYjIMYaGc2yt0I64lUiKCz
	oF1M8xEj4l6qQA3KxS1GSG5paXrXXDnbQtz_GmHydZt_ixe7ML1K_5Jgk8tU
	bcX52AJpPJt9xyQRPj.tPXKZnDPcqi7nS6d6m23.u.c4QPm1efxHJCN1zeDe
	lPmpfzyG.sgyZWwEmeD8prN4xK.0DOZY_I917GEJH5JpwHU21alBM5kp6kU8
	O0M_jsrjQN_VgRqzfODNay3yZgtQGrbXDOi3Nmg--
Received: from [192.71.175.2] by web65414.mail.ac4.yahoo.com via HTTP;
	Thu, 25 Nov 2010 03:37:36 PST
X-Mailer: YahooMailRC/553 YahooMailWebService/0.8.107.285259
Date: Thu, 25 Nov 2010 03:37:36 -0800 (PST)
From: Divakar Singh <dpsmails@yahoo.com>
Subject: Which gives good performance? separate database vs separate schema
To: pgsql-performance@postgresql.org
MIME-Version: 1.0
Content-Type: multipart/alternative; boundary="0-1828418946-1290685056=:83793"
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=0.792 tagged_above=-10 required=5 tests=BAYES_50=0.8,
	HTML_MESSAGE=0.001, RCVD_IN_DNSWL_NONE=-0.0001,
	RFC_ABUSE_POST=0.001, T_RP_MATCHES_RCVD=-0.01
X-Spam-Level: 
X-Archive-Number: 201011/368
X-Sequence-Number: 41392

--0-1828418946-1290685056=:83793
Content-Type: text/plain; charset=us-ascii

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 



      
--0-1828418946-1290685056=:83793
Content-Type: text/html; charset=us-ascii

<html><head><style type="text/css"><!-- DIV {margin:0px;} --></style></head><body><div style="font-family:arial,helvetica,sans-serif;font-size:10pt;color:#000000;">Hello Friends,<br>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.<br>It essentially means that some processes from each instance of the software connect to these tables.<br>Now, should I put these tables in 1 Database's different schemas or in separate databases itself for good performance?<br>I am using libpq for connection.&nbsp;&nbsp; <br><br>Pictorial Representation:<br><br style="font-weight: bold; color: rgb(0, 0, 255);"><span style="font-weight: bold; color: rgb(0, 0, 255);">Process1 -&gt; DB1.schema1.table1</span><br style="font-weight: bold; color: rgb(0, 0, 255);"><br style="font-weight: bold; color: rgb(0, 0, 255);"><span style="font-weight: bold; color:
 rgb(0, 0, 255);">Process2 -&gt; DB1.schema2.table1</span><br><br>&nbsp; Vs.<br><br><span style="font-weight: bold; color: rgb(192, 0, 0);">Process1 -&gt; DB1.default.table1</span><br style="font-weight: bold; color: rgb(192, 0, 0);">
<br style="font-weight: bold; color: rgb(192, 0, 0);">
<span style="font-weight: bold; color: rgb(192, 0, 0);">Process2 -&gt; DB2.default.table1</span><br><br>Which one is better?<br><br><br><div>&nbsp;</div>thanks in advance <br></div><br>

      </body></html>
--0-1828418946-1290685056=:83793--