Re: Simple database, multiple instances? - Mailing list pgsql-performance

From Dimitri Fontaine
Subject Re: Simple database, multiple instances?
Date
Msg-id m2d3pnavbe.fsf@2ndQuadrant.fr
Whole thread Raw
In response to Simple database, multiple instances?  (Mario Splivalo <mario.splivalo@megafon.hr>)
Responses Re: Simple database, multiple instances?  (Mario Splivalo <mario.splivalo@megafon.hr>)
List pgsql-performance
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.

Regards,
--
Dimitri Fontaine
http://2ndQuadrant.fr     PostgreSQL : Expertise, Formation et Support

pgsql-performance by date:

Previous
From: pasman pasmański
Date:
Subject: tidscan not work ? Pg 8.4.5 + WinXP
Next
From: Mario Splivalo
Date:
Subject: Re: Simple database, multiple instances?