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?