Re: Configuring postmaster to use all available memory - Mailing list pgsql-general

From Tom Lane
Subject Re: Configuring postmaster to use all available memory
Date
Msg-id 4593.1045612333@sss.pgh.pa.us
Whole thread Raw
In response to Configuring postmaster to use all available memory  (Joe Tomcat <tomcat@mobile.mp>)
List 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 by date:

Previous
From: Tom Lane
Date:
Subject: Re: Idle transaction causing problems.
Next
From: Justin Clift
Date:
Subject: Re: techdocs broken again.