Re: statement_timeout is not cancelling query

Поиск
Список
Период
Сортировка
От Greg Stark
Тема Re: statement_timeout is not cancelling query
Дата
Msg-id 407d949e0912150907j43014a90wb964d7db07a7609a@mail.gmail.com
обсуждение исходный текст
Ответ на Re: statement_timeout is not cancelling query  (Robert Haas <robertmhaas@gmail.com>)
Ответы Re: statement_timeout is not cancelling query  (Robert Haas <robertmhaas@gmail.com>)
Список pgsql-bugs
On Tue, Dec 15, 2009 at 4:16 PM, Robert Haas <robertmhaas@gmail.com> wrote:
> I didn't know that, but it I think by the time malloc returns 0
> usually other bad things are happening. =A0I don't think that's really
> an answer.

Only if, as Craig said and you disputed, you have overcommit enabled
or lots of swap.

There is a problem though, if you have overcommit disabled you kind of
need lots of swap to avoid running out of virtual memory long before
you're actually short on physical memory. And it's true that Linux has
had trouble dealing with low memory situations in the past few years,
at least in my experience. But that's not true on all OSes and we can
hope it won't be true for Linux forever too.

--=20
greg

В списке pgsql-bugs по дате отправления:

Предыдущее
От: Robert Haas
Дата:
Сообщение: Re: BUG #5244: Attempting to rollback to a savepoint after receiving an error with state 55000 the process hangs
Следующее
От: Robert Haas
Дата:
Сообщение: Re: statement_timeout is not cancelling query