Database in RAM

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

Ryan Mahoney writes:

If you have the ram, does pg need to be optimized to store more data in ram?

You can use the postmaster -B option to allocate more buffers, but
remember to leave enough memory to the kernel for file caching.

--
Peter Eisentraut peter_e@gmx.net http://funkturm.homeip.net/~peter

Yes you need to "tell" it how much of your RAM it can use
by setting the "-B" and "-S" option on startup. See
"man postgres".