"Dann Corbit" <DCorbit@connx.com> writes:
> 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.
You should not assume that more is necessarily better.
In many practical situations, it's better to leave the majority of RAM
free for kernel disk caching.
regards, tom lane