On Tue, Dec 15, 2009 at 5:18 PM, Robert Haas <robertmh...@gmail.com> wrote: > I suppose that I could fix this by getting rid of my swap partition > altogether, but that seems a rather extreme solution, and it's > certainly not the way most UNIX/Linux systems I run across are > configured, if for no other reason than that the operating system > configurator usually recommends creating one.
Well I suppose it's a question of degree. The more swap you have the more you can do before you run out of memory. But nobody said swap performs as well as RAM.... What's the kernel going to do though, refuse to allocate memory when it has swap available? The problem is that the OS gives no feedback on when you're running low on RAM but haven't run out yet. There were experiments in the 90s with a SIGDANGER but I think it never worked great and I don't think it's widespread. If Postgres imposed a limit itself it would a) be hard for it to be a server-wide limit and b) wouldn't take into account other things running on the system. So that doesn't really help either. -- greg -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs