On August 29, 2011 02:34:26 PM you wrote: > On Mon, Aug 29, 2011 at 3:46 PM, Alan Hodgson <ahodg...@simkin.ca> wrote: > > On August 29, 2011 01:36:07 PM Lonni J Friedman wrote: > >> I have several Linux-x68_64 based dedicated PostgreSQL servers where > >> I'm experiencing significant swap usage growth over time. > > > > It's the Linux kernel that does it, not PostgreSQL. Set vm.swappiness=0 > > (usually in /etc/sysctl.conf) and put that into effect. > > that won't help and, in almost all cases, is a bad idea.
Overly aggressive swapping with the default settings has frequently caused me performance issues. Using this prevents those problems. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
