Configuring postmaster to use all available memory

Поиск
Список
Период
Сортировка
От Joe Tomcat
Тема Configuring postmaster to use all available memory
Дата
Msg-id 1045417877.2050.62.camel@linux.local
обсуждение исходный текст
Ответы Re: Configuring postmaster to use all available memory
Re: Configuring postmaster to use all available memory
Список pgsql-general
Hello Psqlers,

I have noticed that postmaster usually doesn't take up that much
memory.  I'm glad it is coded for efficiency, but, I have it running on
a dedicated machine which does absolutely nothing more than allow me to
log in via ssh and run postmaster.  I want postmaster to consume
basically all available RAM, so any query which is a read (not an
updating query) shouldn't have to touch disk at all.  Is there a way to
do this?  I looked at the -B option, and set it as -B 1024 but it didn't
seem to do much.  Should I crank it further up, or are there other
things to do?

Thanks!



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

Предыдущее
От: Martijn van Oosterhout
Дата:
Сообщение: Re: data tyme type
Следующее
От: "scott.marlowe"
Дата:
Сообщение: Re: Idle transaction causing problems.