Re: Configuring postmaster to use all available memory

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Joe Tomcat <tomcat(at)mobile(dot)mp>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Configuring postmaster to use all available memory
Date: 2003-02-18 23:52:13
Message-ID: 4593.1045612333@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Joe Tomcat <tomcat(at)mobile(dot)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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Justin Clift 2003-02-18 23:58:37 Re: techdocs broken again.
Previous Message Tom Lane 2003-02-18 23:49:11 Re: Idle transaction causing problems.