Postgres Pro
Downloads
Home   >   mailing lists

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

From Matthew Wakeling
Subject Re: select on 22 GB table causes "An I/O error occured while sending to the backend." exception
Date
Msg-id alpine.DEB.1.10.0808281702450.4454@aragorn.flymine.org
Whole thread Raw
In response to Re: select on 22 GB table causes "An I/O error occured while sending to the backend." exception  (Steve Atkins <steve@blighty.com>)
Responses Re: select on 22 GB table causes "An I/O error occured while sending to the backend." exception  (Craig James <craig_james@emolecules.com>)
List pgsql-performance
Tree view 
On Thu, 28 Aug 2008, Steve Atkins wrote:
>> Probably the best solution is to just tell the kernel somehow to never kill
>> the postmaster.
>
> Or configure adequate swap space?

Oh yes, that's very important. However, that gives the machine the
opportunity to thrash.

Matthew

--
The early bird gets the worm. If you want something else for breakfast, get
up later.

pgsql-performance by date:

Previous
From: Craig James
Date:
Subject: Re: select on 22 GB table causes "An I/O error occured while sending to the backend." exception
Next
From: david@lang.hm
Date:
Subject: Re: select on 22 GB table causes "An I/O error occured while sending to the backend." exception