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



---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?

http://archives.postgresql.org

"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

---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@postgresql.org so that your
message can get through to the mailing list cleanly

Hello Tom,

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

Thank you for your answer. Will this also be done automaticly on a windows
server 2003 server?

When I am looking at the task manager postgresql is only consuming 10MB and
there are 2GB Free of memory.
I have enought data that postgresql could load into the memory.

On the other hand I think as it is a disk caching issue I won't see anything
in the task-manager.
Maybe windows does not have such a disk caching or I haven't found it?

Thank you,

Christian



---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster