[postgis-users] Memory usage optimized for postgresql/postgis

[Andreas Laggner]

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


-- 
Dipl. Geoökologe Andreas Laggner

Institut für Agrarrelevante Klimaforschung (AK) des vTI
Arbeitsgruppe Emissionsinventare
Johann Heinrich von Thünen-Institut (vTI),
Bundesforschungsinstitut für Ländliche Räume, Wald und Fischerei

Institute of Agricultural Climate Research (AK) of the vTI
Johann Heinrich von Thünen-Institute (vTI),
Federal Research Institute for Rural Areas, Forestry and Fisheries

Bundesallee 50
D-38116 Braunschweig

Tel.: (+49) (0)531 596 2636
E-mail: andreas.laggner at vti.bund.de
Homepage: http://www.vti.bund.de