pg.ddx.io pgsql-sql@postgresql.org mailing list archive
help / color / mirror / Atom feed2 tables or two db?
2+ messages / 2 participants
[nested] [flat]
* 2 tables or two db?
@ 2009-06-18 15:22 ivan marchesini <marchesini@unipg.it>
0 siblings, 1 reply; 2+ messages in thread
From: ivan marchesini @ 2009-06-18 15:22 UTC (permalink / raw)
To: pgsql-sql
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
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: 2 tables or two db?
@ 2009-06-18 15:32 Rob Sargent <robjsargent@gmail.com>
parent: ivan marchesini <marchesini@unipg.it>
0 siblings, 0 replies; 2+ messages in thread
From: Rob Sargent @ 2009-06-18 15:32 UTC (permalink / raw)
To: ; +Cc: pgsql-sql
ivan marchesini wrote:
> 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
>
>
>
>
>
My guess is that only physical separation will have any positive impact
otherwise the two datasets are competing for the same resources. At
least separate discs, controllers to avoid disc contention. Separate
postgres instances to allow separate caches (in affect separate memory).
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2009-06-18 15:32 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2009-06-18 15:22 2 tables or two db? ivan marchesini <marchesini@unipg.it>
2009-06-18 15:32 ` Rob Sargent <robjsargent@gmail.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox