PostgreSQL and memory usage

From: "Dann Corbit" <DCorbit(at)connx(dot)com>
To: <pgsql-hackers(at)postgresql(dot)org>, <pgsql-general(at)postgresql(dot)org>
Subject: PostgreSQL and memory usage
Date: 2003-01-07 03:16:24
Message-ID: D90A5A6C612A39408103E6ECDD77B8294CD790@voyager.corporate.connx.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-hackers

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.

How can I optimize the use of PostgreSQL to get the maximum throughput
in a configuration like that?

Are there any memory usage/tuning documents I can read?

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2003-01-07 03:30:22 Re: PostgreSQL and memory usage
Previous Message Tom Lane 2003-01-07 03:15:33 Re: [HACKERS] I feel the need for speed. What am I doing wrong?

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2003-01-07 03:30:22 Re: PostgreSQL and memory usage
Previous Message Tom Lane 2003-01-07 03:15:33 Re: [HACKERS] I feel the need for speed. What am I doing wrong?