Re: performance difference: multiple db vs single db

Поиск
Список
Период
Сортировка
От John Liu
Тема Re: performance difference: multiple db vs single db
Дата
Msg-id 200402051711.i15HBg1T020081@mail.stihealthcare.com
обсуждение исходный текст
Ответы Re: performance difference: multiple db vs single db  ("John Sidney-Woollett" <johnsw@wardbrook.com>)
Список 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



В списке pgsql-general по дате отправления:

Предыдущее
От: "scott.marlowe"
Дата:
Сообщение: Re: Proper tool to display graphics?
Следующее
От: Tom Lane
Дата:
Сообщение: Re: size of mailing lists?