Re: select on 22 GB table causes "An I/O error occured while sending to the backend." exception
От | Gregory Williamson |
---|---|
Тема | Re: select on 22 GB table causes "An I/O error occured while sending to the backend." exception |
Дата | |
Msg-id | 8B319E5A30FF4A48BE7EEAAF609DB233021F3299@COMAIL01.digitalglobe.com обсуждение исходный текст |
Ответ на | select on 22 GB table causes "An I/O error occured while sending to the backend." exception (henk de wit <henk53602@hotmail.com>) |
Ответы |
Re: select on 22 GB table causes "An I/O error occured while sending to the backend." exception
|
Список | pgsql-performance |
Bill Moran wrote:
> In response to Greg Smith <gsmith@gregsmith.com>:
>
>> <snipped...>
>
> I don't know, Greg. First off, the solution of making the postmaster
> immune to the OOM killer seems better than disabling overcommit to me
> anyway; and secondly, I don't understand why we should avoid making
> the PG documentation as comprehensive as possible, which seems to be
> what you are saying: "we shouldn't make the PG documentation too
> comprehensive, because then it will get very big"
I think it would be a hopeless morass for PostgreSQL to try to document each evolution of each OS it runs under; the general caveat seems fine, although perhaps adding something to the effect of "search the archives for possible specifics" might be in order. But tracking postgres's own shifts and requirements seems daunting enough w/out adding in endless flavours of different OSs.
My $0.02 worth ...
Greg Williamson
Senior DBA
DigitalGlobe
Confidentiality Notice: This e-mail message, including any attachments, is for the sole use of the intended recipient(s) and may contain confidential and privileged information and must be protected in accordance with those provisions. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message.
(My corporate masters made me say this.)
В списке pgsql-performance по дате отправления: