Re: Enough RAM for entire Database.. cost aside, is this

Поиск
Список
Период
Сортировка
От Andy B
Тема Re: Enough RAM for entire Database.. cost aside, is this
Дата
Msg-id rbcFc.6326$HQ1.5177@fe2.news.blueyonder.co.uk
обсуждение исходный текст
Ответ на Enough RAM for entire Database.. cost aside, is this going to be fastest?  ("Andy B" <abhousehuntRE-M--O--V-E@blueyonder.co.uk>)
Список pgsql-general
Hello Shridhar,

Thanks for the reply.

> There is no reason why you should not do it. How remains to be a point of
> disagreement though. You don't allocate 16GB of shared buffers to
postgresql.
> That won't give you performance you need.

I think in the other thread, Tom was alluding to this too. What is it about
the shared buffer cache behaviour that makes it inefficient when it is very
large? (assuming that the address space it occupies is allocated to RAM
pages)

Is there a good place I could look for some in depth details of its
behaviour?

Many thanks,
Andy



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

Предыдущее
От: "Andy B"
Дата:
Сообщение: Re: postgresql +AMD64 +big address spaces - does it work?
Следующее
От: "Andy B"
Дата:
Сообщение: Re: Enough RAM for entire Database.. cost aside, is this