Re: select on 22 GB table causes "An I/O error occured while sending to the backend." exception

Поиск

Список

Период

Сортировка

От	Bill Moran
Тема	Re: select on 22 GB table causes "An I/O error occured while sending to the backend." exception
Дата	28 августа 2008 г. 10:54:03
Msg-id	20080828095325.3c95f867.wmoran@collaborativefusion.com обсуждение
Ответ на	Re: select on 22 GB table causes "An I/O error occured while sending to the backend." exception (Matthew Wakeling <matthew@flymine.org>)
Ответы	Re: select on 22 GB table causes"An I/O error occured while sending to the backend." exception Re: select on 22 GB table causes "An I/O error occured while sending to the backend." exception
Список	pgsql-performance

Дерево обсуждения

In response to Matthew Wakeling <matthew@flymine.org>:
>
> Probably the best solution is to just tell the kernel somehow to never
> kill the postmaster.

This thread interested me enough to research this a bit.

In linux, it's possible to tell the OOM killer never to consider
certain processes for the axe, using /proc magic.  See this page:
http://linux-mm.org/OOM_Killer

Perhaps this should be in the PostgreSQL docs somewhere?

--
Bill Moran
Collaborative Fusion Inc.
http://people.collaborativefusion.com/~wmoran/

wmoran@collaborativefusion.com
Phone: 412-422-3463x4023

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

Вход в личный кабинет

Восстановление пароля

Подтверждение аккаунта

Изменение пароля

Re: select on 22 GB table causes "An I/O error occured while sending to the backend." exception