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?