Andreas Laggner wrote:
Hello List,
i have a server only running PostGIS with 32GB RAM (no other
applications), but linux is swapping when i start more queries and has
still 26GB memory cached!!
In my experience PostGIS becomes very slow if linux swaps - so i put the
maximum of RAM into the PC. But it seems some options must be set to
make linux giving the memory to PostgreSQL, anybody who knows the
required options settings?
cheers Andi
Hi Andi,
We're quite fortunate in that we delegate all of the memory management
to PostgreSQL, and so what you really want is a PostgreSQL memory tuning
guide.
There is a reasonably good explanation of the various parameters in the
manual itself, but otherwise there are plenty of resources available to
find using Google.
HTH,
Mark.
--
Mark Cave-Ayland - Senior Technical Architect
PostgreSQL - PostGIS
Sirius Corporation plc - control through freedom
http://www.siriusit.co.uk
t: +44 870 608 0063
_______________________________________________
postgis-users mailing list
[email protected]
http://postgis.refractions.net/mailman/listinfo/postgis-users
