Received: from maia.hub.org (maia-2.hub.org [200.46.204.251]) by mail.postgresql.org (Postfix) with ESMTP id 16927133655C for ; Thu, 25 Nov 2010 08:09:14 -0400 (AST) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.251]) (amavisd-maia, port 10024) with ESMTP id 76845-06 for ; Thu, 25 Nov 2010 12:09:07 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from elizabeth.gransy.com (elizabeth.gransy.com [89.187.132.199]) by mail.postgresql.org (Postfix) with ESMTP id D3B81133616B for ; Thu, 25 Nov 2010 08:09:06 -0400 (AST) Received: from sq.gransy.com (localhost [127.0.0.1]) by elizabeth.gransy.com (Postfix) with ESMTP id DEBAD15E412E; Thu, 25 Nov 2010 13:09:06 +0100 (CET) Received: from 85.162.33.90 (SquirrelMail authenticated user tv@fuzzy.cz) by sq.gransy.com with HTTP; Thu, 25 Nov 2010 13:09:06 +0100 Message-ID: <6849f7cc542b37d0b6650fa9f310efb5.squirrel@sq.gransy.com> In-Reply-To: References: <991565.83793.qm@web65414.mail.ac4.yahoo.com> Date: Thu, 25 Nov 2010 13:09:06 +0100 Subject: Re: Which gives good performance? separate database vs separate schema From: tv@fuzzy.cz To: "Thomas Kellerer" Cc: pgsql-performance@postgresql.org User-Agent: SquirrelMail/1.4.21 MIME-Version: 1.0 Content-Type: text/plain;charset=utf-8 Content-Transfer-Encoding: 8bit X-Priority: 3 (Normal) Importance: Normal X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.8 tagged_above=-10 required=5 tests=BAYES_50=0.8 X-Spam-Level: X-Archive-Number: 201011/371 X-Sequence-Number: 41395 > 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