Received: from maia.hub.org (unknown [200.46.204.183]) by mail.postgresql.org (Postfix) with ESMTP id E52956328DB for ; Thu, 18 Jun 2009 12:24:42 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 29109-06 for ; Thu, 18 Jun 2009 12:24:42 -0300 (ADT) X-Greylist: delayed 00:22:36.791048 by SQLgrey-1.7.6 Received: from trabant.cianoz.org (host31-194-149-62.serverdedicati.aruba.it [62.149.194.31]) by mail.postgresql.org (Postfix) with ESMTP id 051C3632707 for ; Thu, 18 Jun 2009 12:24:40 -0300 (ADT) Received: from [192.168.100.8] (mfalcon.irpi.cnr.it [194.119.218.2]) by trabant.cianoz.org (Postfix) with ESMTP id 06AF550C8F for ; Thu, 18 Jun 2009 17:01:59 +0200 (CEST) Subject: 2 tables or two db? From: ivan marchesini Reply-To: marchesini@unipg.it To: pgsql-sql@postgresql.org Content-Type: text/plain Organization: University of Perugia Date: Thu, 18 Jun 2009 17:22:15 +0200 Message-Id: <1245338535.15412.4.camel@ivangeo> Mime-Version: 1.0 X-Mailer: Evolution 2.26.1.1 Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.1 tagged_above=0 required=5 tests=RDNS_DYNAMIC=0.1 X-Spam-Level: X-Archive-Number: 200906/86 X-Sequence-Number: 32691 Dear postgres users, Suppose I have two tables of data. suppose the two table are really similar in dimensions suppose they will receive the same number and type of queries. in tems of performance (velocity of answer) it is better to place the two tables in the same db or into two different db? may be it is a stupid question, but.... many many thanks... Ivan