Re: Is IDLE session really idle? - Mailing list pgsql-admin

From Michael Monnerie
Subject Re: Is IDLE session really idle?
Date
Msg-id 200906152235.55192@zmi.at
Whole thread Raw
In response to Is IDLE session really idle?  (Igor Polishchuk <ipolishchuk@hi5.com>)
List pgsql-admin
On Montag 15 Juni 2009 Igor Polishchuk wrote:
> I see two ways to solve the problem.:

Why not just increase
vm.swappiness = 100
in /etc/sysctl.conf, and/or use ramzswap? That will swap out unneeded
memory very fast, and free it for use by others.

There was an article on lwn.net recently:
http://lwn.net/SubscriberLink/334649/76bbe60a81cfc7f5/
( Compcache: in-memory compressed swapping )
If installed it on several servers, and my desktop. quite nice:
Compresses 2GB to 512MB on my desktop, or 494MB to 186MB on a server.

Even if staying with "normal" swap, increasing the swappiness can
quickly free memory, but swap I/O might slow things down, depending on
your setup.

mfg zmi
--
// Michael Monnerie, Ing.BSc    -----      http://it-management.at
// Tel: 0660 / 415 65 31                      .network.your.ideas.
// PGP Key:         "curl -s http://zmi.at/zmi.asc | gpg --import"
// Fingerprint: AC19 F9D5 36ED CD8A EF38  500E CE14 91F7 1C12 09B4
// Keyserver: wwwkeys.eu.pgp.net                  Key-ID: 1C1209B4


pgsql-admin by date:

Previous
From: Tino Schwarze
Date:
Subject: Re: Is IDLE session really idle?
Next
From: Scott Marlowe
Date:
Subject: Re: Is IDLE session really idle?