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

[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