Re: performance difference: multiple db vs single db

From: "John Liu" <johnl(at)emrx(dot)com>
To: <pgsql-general(at)postgresql(dot)org>
Subject: Re: performance difference: multiple db vs single db
Date: 2004-02-05 17:09:53
Message-ID: 200402051711.i15HBg1T020081@mail.stihealthcare.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


Here're two cases -
1. 20 tables in one huge database A on one machine
2. 10 tables in each database if they can functionally separated, so two
databases A1 and A2 on one machine

What's the estimated performance difference on queries from A2 and A1
comparing the same querying from A in general using PostgreSQL?
1) What if A1 contains 10 bigger tables [80% of A], A2 container 10 tables
with less data [20% of A]
2) And A1 and A2 contains 50% of A each

Thanks.

johnl

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2004-02-05 17:15:26 Re: size of mailing lists?
Previous Message scott.marlowe 2004-02-05 16:27:30 Re: Proper tool to display graphics?