Skip site navigation (1) Skip section navigation (2)

Re: Which gives good performance? separate database vs separate schema

From: Thomas Kellerer <spam_eater(at)gmx(dot)net>
To: pgsql-performance(at)postgresql(dot)org
Subject: Re: Which gives good performance? separate database vs separate schema
Date: 2010-11-25 12:03:29
Message-ID: icljah$8pe$1@dough.gmane.org (view raw or flat)
Thread:
Lists: pgsql-performance
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


In response to

Responses

pgsql-performance by date

Next:From: tvDate: 2010-11-25 12:09:06
Subject: Re: Which gives good performance? separate database vs separate schema
Previous:From: tvDate: 2010-11-25 12:02:08
Subject: Re: Which gives good performance? separate database vs separate schema

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group