Re: Database in RAM - Mailing list pgsql-general

From Bruce Momjian
Subject Re: Database in RAM
Date
Msg-id 200105031544.f43Fi5Q27228@candle.pha.pa.us
Whole thread Raw
In response to Database in RAM  (Ryan Mahoney <ryan@paymentalliance.net>)
List pgsql-general
> If you have the ram, does pg need to be optimized to store more data in ram?
>
> -r

I would recommend increasing the number of PostgreSQL shared buffers
with the PostgreSQL -B switch.  You can read my new performance article:

    http://candle.pha.pa.us/main/writings/pgsql/performance/index.html


It talks about memory usage and performance.

--
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026

pgsql-general by date:

Previous
From: "Albertson, Chris"
Date:
Subject: RE: Time to insert
Next
From: Peter Eisentraut
Date:
Subject: Re: View Queries to server