Home > mailing lists

PostgreSQL and memory usage - Mailing list pgsql-general

From	Dann Corbit
Subject	PostgreSQL and memory usage
Date	January 7, 2003 01:16:24
Msg-id	D90A5A6C612A39408103E6ECDD77B8294CD790@voyager.corporate.connx.com Whole thread Raw
Responses	Re: PostgreSQL and memory usage (Tom Lane <tgl@sss.pgh.pa.us>)
List	pgsql-general

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?

From: Tom Lane
Date: 07 January 2003, 01:15:34
Subject: Re: [HACKERS] I feel the need for speed. What am I doing wrong?

From: "Boget, Chris"
Date: 07 January 2003, 01:25:12
Subject: Timestamp