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

Поиск
Список
Период
Сортировка
От Andrew Sullivan
Тема Re: select on 22 GB table causes "An I/O error occured while sending to the backend." exception
Дата
Msg-id 20080828123645.GB23588@commandprompt.com
обсуждение исходный текст
Ответ на Re: select on 22 GB table causes "An I/O error occured while sending to the backend." exception  (david@lang.hm)
Список pgsql-performance
On Wed, Aug 27, 2008 at 03:22:09PM -0700, david@lang.hm wrote:
>
> I disagree with you. I think goof Postgres operation is so highly dependant
> on caching as much data as possible that disabling overcommit (and throwing
> away a lot of memory that could be used for cache) is a solution that's as
> bad or worse than the problem it's trying to solve.

Ok, but the danger is that the OOM killer kills your postmaster.  To
me, this is a cure way worse than the disease it's trying to treat.
YMMD &c. &c.

A

--
Andrew Sullivan
ajs@commandprompt.com
+1 503 667 4564 x104
http://www.commandprompt.com/

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

Предыдущее
От: "H. Hall"
Дата:
Сообщение: Re: indexing for distinct search in timestamp based table
Следующее
От: Matthew Wakeling
Дата:
Сообщение: Re: select on 22 GB table causes "An I/O error occured while sending to the backend." exception