[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...@vti.bund.de
Homepage: http://www.vti.bund.de

_______________________________________________
postgis-users mailing list
postgi...@postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users

[Mark Cave-Ayland]

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