Configuring postmaster to use all available memory

From: Joe Tomcat <tomcat(at)mobile(dot)mp>
To: pgsql-general(at)postgresql(dot)org
Subject: Configuring postmaster to use all available memory
Date: 2003-02-16 17:51:17
Message-ID: 1045417877.2050.62.camel@linux.local
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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!

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2003-02-16 18:03:42 Re: Index not used with IS NULL
Previous Message Doug McNaught 2003-02-16 17:39:30 Re: Question on 'create domain'