Re: PostgreSQL and memory usage

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Dann Corbit" <DCorbit(at)connx(dot)com>
Cc: pgsql-hackers(at)postgresql(dot)org, pgsql-general(at)postgresql(dot)org
Subject: Re: PostgreSQL and memory usage
Date: 2003-01-07 03:30:22
Message-ID: 9594.1041910222@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-hackers

"Dann Corbit" <DCorbit(at)connx(dot)com> writes:
> I have a machine with 4 CPU's and 2 gigabytes of physical ram.
> I would like to get PostgreSQL to use as much memory as possible. I
> can't seem to get PostgreSQL to use more than 100 megabytes or so.

You should not assume that more is necessarily better.

In many practical situations, it's better to leave the majority of RAM
free for kernel disk caching.

regards, tom lane

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Dann Corbit 2003-01-07 03:32:52 Re: PostgreSQL and memory usage
Previous Message Dann Corbit 2003-01-07 03:16:24 PostgreSQL and memory usage

Browse pgsql-hackers by date

  From Date Subject
Next Message Dann Corbit 2003-01-07 03:32:52 Re: PostgreSQL and memory usage
Previous Message Dann Corbit 2003-01-07 03:16:24 PostgreSQL and memory usage