Re: shared_buffers/effective_cache_size on 96GB server

Поиск
Список
Период
Сортировка
От Shaun Thomas
Тема Re: shared_buffers/effective_cache_size on 96GB server
Дата
Msg-id 5075BC09.8010006@optionshouse.com
обсуждение исходный текст
Ответ на Re: shared_buffers/effective_cache_size on 96GB server  (Claudio Freire <klaussfreire@gmail.com>)
Ответы Re: shared_buffers/effective_cache_size on 96GB server
Список pgsql-performance
On 10/10/2012 12:05 PM, Claudio Freire wrote:

> Why does nobody every mention that concurrent access has to be taken
> into account?

That's actually a good point. But if you have one giant database, the
overlap of which tables are being accessed by various sessions is going
to be immense.

There probably should be a point about this in the docs, though. There
are more and more shared-hosting setups or places that spread their data
horizontally across separate databases for various clients, and in those
cases, parallel usage does not imply overlap.

--
Shaun Thomas
OptionsHouse | 141 W. Jackson Blvd. | Suite 500 | Chicago IL, 60604
312-444-8534
sthomas@optionshouse.com

______________________________________________

See http://www.peak6.com/email_disclaimer/ for terms and conditions related to this email


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

Предыдущее
От: Claudio Freire
Дата:
Сообщение: Re: Hyperthreading (was: Two identical systems, radically different performance)
Следующее
От: Claudio Freire
Дата:
Сообщение: Re: shared_buffers/effective_cache_size on 96GB server