Re: Problem with very big queries.

On Friday 11 April 2008 02:04:42 Dave Cramer wrote:
> First you should upgrade your server to 8.0.15
>
> The server is segfaulting. The driver is just reporting that the
> server crashed.
Hi!

I am using 8.0.15 postgres server and unfortunately can't upgrade to 8.3
since I am using sp-gist tries. So, there is a limit in the allowable query
length?

Thanks.

>
> Dave
>
> On 10-Apr-08, at 6:52 PM, Panagiotis Papadakos wrote:
> > Hello everybody.
> >
> > I want to send to postgresql-8.0 a very big query,
> > select * from table where lala IN (....)
> > Inside IN there are almost 60000 values.
> >
> > Unfortunately, the server terminates with a singal 11 and I get
> > to my console the following:
> >
> > An I/O error occured while sending to the backend.
> > An I/O error occured while sending to the backend.
> >
> > jdbc version is 8.0-322 JDBC 3.
> >
> > Could anybody help?
> >
> > Regards.
> >
> > --
> > Sent via pgsql-jdbc mailing list (pgsql-jdbc(at)postgresql(dot)org)
> > To make changes to your subscription:
> > http://www.postgresql.org/mailpref/pgsql-jdbc