Postgresql.conf - which param for in memory keys and tables? - Mailing list pgsql-novice

From Christian Hofmann
Subject Postgresql.conf - which param for in memory keys and tables?
Date
Msg-id 010701c6858d$7a0dde50$2100a8c0@taschenrechner
Whole thread Raw
Responses Re: Postgresql.conf - which param for in memory keys and tables?  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-novice
Hello,

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.

I would guess these are parameters like work_mem or maintenance_work_mem,
but I am not sure.

Thank you,

Christian



pgsql-novice by date:

Previous
From: "Marcel Franke"
Date:
Subject: Re: pgrestore, notice, will create implicit.
Next
From: "Keith D. Evans"
Date:
Subject: Re: searching multiple tables