"Christian Hofmann" <christian(dot)hofmann(at)gmx(dot)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