Received: from unknown (HELO gamersmafia.com) (80.38.119.191) by 0 with SMTP; 25 Mar 2003 20:34:05 -0000 Message-ID: <3E80BCBE.3000205@gamersmafia.com> Date: Tue, 25 Mar 2003 21:31:58 +0100 From: dharana User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.3a) Gecko/20021212 X-Accept-Language: en-us, en MIME-Version: 1.0 To: pgsql-performance@postgresql.org Subject: What's better: one huge database or several smaller ones? Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit X-Spam-Status: No, hits=0.0 required=10.0 tests= version=2.20 X-Spam-Level: I'm planning to develop a website network with n network nodes. There will be a central node (website) wich will summarize information from all the network nodes. It will be also possible to use data between nodes (node A showing own data + data from node B). Table structures between nodes will be identical. So my question is: what should i do, put all the data in one huge database or spread it in several nearly identical databases? Data generated will grow at a rate of ~ 250Mb/year; 10000 rows per table (size is physical space of /var/lib/postgres/data after vacuum analyze, this dir contains only one database). Thank you in advance, dharana