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

From tv@fuzzy.cz
Subject Re: Which gives good performance? separate database vs separate schema
Date
Msg-id 6849f7cc542b37d0b6650fa9f310efb5.squirrel@sq.gransy.com
Whole thread Raw
In response to Re: Which gives good performance? separate database vs separate schema  (Thomas Kellerer <spam_eater@gmx.net>)
List pgsql-performance
> 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


pgsql-performance by date:

Previous
From: Thomas Kellerer
Date:
Subject: Re: Which gives good performance? separate database vs separate schema
Next
From: Andres Freund
Date:
Subject: Re: Which gives good performance? separate database vs separate schema