Postgres Pro
Downloads
Home   >   mailing lists

Re: Which gives good performance? separate database vs separate schema - Mailing list pgsql-performance

From Thomas Kellerer
Subject Re: Which gives good performance? separate database vs separate schema
Date
Msg-id icljah$8pe$1@dough.gmane.org
Whole thread Raw
In response to Which gives good performance? separate database vs separate schema  (Divakar Singh <dpsmails@yahoo.com>)
Responses Re: Which gives good performance? separate database vs separate schema  (tv@fuzzy.cz)
List pgsql-performance
Tree view 
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
Postgresdoes not support cross-database queries. 

Regards
Thomas

pgsql-performance by date:

Previous
From: tv@fuzzy.cz
Date:
Subject: Re: Which gives good performance? separate database vs separate schema
Next
From: tv@fuzzy.cz
Date:
Subject: Re: Which gives good performance? separate database vs separate schema