Re: Which gives good performance? separate database vs separate schema

Поиск
Список
Период
Сортировка
От Andres Freund
Тема Re: Which gives good performance? separate database vs separate schema
Дата
Msg-id 201011251310.17080.andres@anarazel.de
обсуждение исходный текст
Ответ на Re: Which gives good performance? separate database vs separate schema  (tv@fuzzy.cz)
Ответы Re: Which gives good performance? separate database vs separate schema  (tv@fuzzy.cz)
Список pgsql-performance
On Thursday 25 November 2010 13:02:08 tv@fuzzy.cz wrote:
> I don't think you'll get performance improvement from running two
> PostgreSQL clusters (one for DB1, one for DB2). And when running two
> databases within the same cluster, there's no measurable performance
> difference AFAIK.
That one is definitely not true in many circumstances. As soon as you start to
hit contention (shared memory, locks) you may very well be better of with two
separate clusters.

Andres

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

Предыдущее
От: tv@fuzzy.cz
Дата:
Сообщение: Re: Which gives good performance? separate database vs separate schema
Следующее
От: tv@fuzzy.cz
Дата:
Сообщение: Re: Which gives good performance? separate database vs separate schema