Re: Configuring postmaster to use all available memory

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Configuring postmaster to use all available memory
Дата
Msg-id 4593.1045612333@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Configuring postmaster to use all available memory  (Joe Tomcat <tomcat@mobile.mp>)
Список pgsql-general
Joe Tomcat <tomcat@mobile.mp> writes:
> I want postmaster to consume
> basically all available RAM,

This is generally considered a bad idea.

> so any query which is a read (not an
> updating query) shouldn't have to touch disk at all.

You do not need to mess with Postgres' settings to make that happen.
The kernel should buffer recently-accessed disk blocks in free RAM,
without you having to do anything special.

See the list archives for much more on the theory and practice of
buffer tuning.

            regards, tom lane

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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Idle transaction causing problems.
Следующее
От: Justin Clift
Дата:
Сообщение: Re: techdocs broken again.