A-Original-Client-UID: 188.129.107.2 splivalo
Message-ID: <4CF4EEA0.6010409@megafon.hr>
Date: Tue, 30 Nov 2010 13:31:28 +0100
From: Mario Splivalo <mario.splivalo@megafon.hr>
User-Agent: Mozilla/5.0 (X11; U; Linux x86_64; en-US;
	rv:1.9.1.15) Gecko/20101027 Lightning/1.0b1 Thunderbird/3.0.10
MIME-Version: 1.0
To: Dimitri Fontaine <dimitri@2ndQuadrant.fr>
CC: pgsql-performance@postgresql.org
Subject: Re: Simple database, multiple instances?
References: <4CF244DA.70206@megafon.hr> <m2d3pnavbe.fsf@2ndQuadrant.fr>
In-Reply-To: <m2d3pnavbe.fsf@2ndQuadrant.fr>
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 7bit

On 11/30/2010 12:45 PM, Dimitri Fontaine wrote:
> Mario Splivalo<mario.splivalo@megafon.hr>  writes:
>> I have simple database schema, containing just three tables:
>>
>> samples, drones, drones_history.
>>
>> Now, those tables hold data for the drones for a simulation. Each simulation
>> dataset will grow to around 10 GB in around 6 months.
>>
>> Since the data is not related in any way I was thinking in separating each
>> simulation into it's own database. That way it would be much easier for me
>> to, at later date, move some of the databases to other servers (when dataset
>> grows beyond the original server storage capacity limit).
>
> Do you intend to run queries across multiple simulations at once? If
> yes, you want to avoid multi databases. Other than that, I'd go with a
> naming convention like samples_<simulation id>  and maybe some
> inheritance to ease querying multiple simulations.

Nope, those 'realms' are completely separated, I'll just have hundreds 
of them. But each of them is in it's separate 'universe', they're not 
aware of each other in any way (i might be creating some statistics, but 
that is going to be really rarely).

	Mario