Memory management - Mailing list pgsql-admin

From Rémy Dufour
Subject Memory management
Date
Msg-id 000801bfe6b5$b1d72800$090a0a0a@prog
Whole thread Raw
List pgsql-admin
Hi there,
 
Recently, I've installed postgres 6.5 on a P3 450 396 megs of RAM. I'm
running Linux RedHat 6.2. I got a few db on it and one has around 2 millions records. When I boot my server, I do a 'free' and it tells me that I got around 300 megs of RAM free.
 
After I do a couple of requests like "Select count(ID) from Store" the memory fills itself and my system swaps a bit.
 
So, is there a way to limit the memory postgresql is allowed to use?
 
And, if anyone can point me out some docs or references on how postgresql/linux
 manage its memory.
 
I would just add more memory to my machine, but it seems to me that it will always fills itself and swap some.
 
Regards,
 
Remy Dufour
IT Programmer
WebNet Inc - ISP
remy.tech@webnet.qc.ca

pgsql-admin by date:

Previous
From: "Yadira M. Rodriguez"
Date:
Subject: No such function 'to_char' with the specified attributes
Next
From: rob
Date:
Subject: type oidvector undefined??