Re: Is IDLE session really idle?

From: Michael Monnerie <michael(dot)monnerie(at)is(dot)it-management(dot)at>
To: pgsql-admin(at)postgresql(dot)org
Subject: Re: Is IDLE session really idle?
Date: 2009-06-15 20:35:54
Message-ID: 200906152235.55192@zmi.at
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Scott Marlowe 2009-06-15 21:13:00 Re: Is IDLE session really idle?
Previous Message Tino Schwarze 2009-06-15 20:33:08 Re: Is IDLE session really idle?