From: tv@fuzzy.cz
To: Thomas Kellerer <spam_eater@gmx.net>
Cc: pgsql-performance@postgresql.org
Subject: Re: Which gives good performance? separate database vs separate schema
Date: Thu, 25 Nov 2010 13:09:06 +0100
Message-ID: <6849f7cc542b37d0b6650fa9f310efb5.squirrel@sq.gransy.com> (raw)
In-Reply-To: <icljah$8pe$1@dough.gmane.org>
References: <991565.83793.qm@web65414.mail.ac4.yahoo.com>
<icljah$8pe$1@dough.gmane.org>
> 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.
Well, there's dblink contrib module, but that won't improve performance.
Tomas
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: tv@fuzzy.cz, spam_eater@gmx.net
Subject: Re: Which gives good performance? separate database vs separate schema
In-Reply-To: <6849f7cc542b37d0b6650fa9f310efb5.squirrel@sq.gransy.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