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: [email protected] Homepage: http://www.vti.bund.de _______________________________________________ postgis-users mailing list [email protected] http://postgis.refractions.net/mailman/listinfo/postgis-users
