Re: statement_timeout is not cancelling query

On Tue, Dec 15, 2009 at 5:18 PM, Robert Haas <robertmhaas(at)gmail(dot)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