Skip site navigation (1) Skip section navigation (2)

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

From: Shane Ambler <pgsql(at)Sheeky(dot)Biz>
To: Bill Moran <wmoran(at)collaborativefusion(dot)com>
Cc: henk de wit <henk53602(at)hotmail(dot)com>, "pgsql-performance(at)postgresql(dot)org" <pgsql-performance(at)postgresql(dot)org>
Subject: Re: select on 22 GB table causes "An I/O error occured while sending to the backend." exception
Date: 2008-08-27 16:45:52
Message-ID: 48B584C0.6080204@Sheeky.Biz (view raw or flat)
Thread:
Lists: pgsql-performance
Bill Moran wrote:

> On a side note, what version of PG are you using?  If it was in a 
> previous email, I missed it.
> 
He mentioned 8.3.1 in the first email.
Although nothing stands out in the 8.3.2 or 8.3.3 fix list (without 
knowing his table structure or any contrib modules used) I wonder if
one of them may resolve his issue.

I also wonder if the error is actually sent back from postgresql or
whether jdbc is throwing the exception because of a timeout waiting for
a response. I would think that with the table in use having 22GB data
and 13GB indexes that the long running query has a chance of creating a
delay on the connections that is long enough to give jdbc the impression
that it isn't responding - generating a misleading error code of "An I/O
error" (meaning we know the server got the request but the response from
the server isn't coming back)

Can you increase the timeout settings on the insert connections that are
failing?




-- 

Shane Ambler
pgSQL (at) Sheeky (dot) Biz

Get Sheeky @ http://Sheeky.Biz

In response to

pgsql-performance by date

Next:From: Jerry ChamplinDate: 2008-08-27 20:21:41
Subject: Re: Is there a way to SubPartition?
Previous:From: Matthew WakelingDate: 2008-08-27 14:10:28
Subject: Re: Is there a way to SubPartition?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group