Re: Postgresql.conf - which param for in memory keys and tables?

"Christian Hofmann" <christian.hofmann@gmx.de> writes:
> Which param will I need to increase when I want postgresql to store the most
> requested keys, maximum 500 MB, in memory and to store the mos requested
> datasets, maximum 750 MB, in memory.
> So when there is a select statement the memory will be consumed instead of
> the slow disks.

This happens automatically because of kernel disk caching; you shouldn't
have to worry about it, assuming that you do actually have enough
memory.

            regards, tom lane