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

Re: Slow query after upgrades

From: Kris Jurka <books(at)ejurka(dot)com>
To: Albert László-Róbert <albertlaszlorobert(at)gmail(dot)com>
Cc: Tom Duffey <tduffey(at)techbydesign(dot)com>, pgsql-jdbc(at)postgresql(dot)org
Subject: Re: Slow query after upgrades
Date: 2007-12-14 10:24:16
Message-ID: Pine.BSO.4.64.0712140522480.15803@leary.csoft.net (view raw or flat)
Thread:
Lists: pgsql-jdbc

On Fri, 14 Dec 2007, Albert Lszl-Rbert wrote:

> the performance before were arount 1-2 minutes ... and after the upgrade
> it was about 30-40 minutes and more ... but because our application is
> running throw the internet using the CORBA technology in most of the
> cases the database throws an org.postgresql.util.PSQLException(: An I/O
> error occured while sending to the backend.) exception.
>

I don't understand why running slower results in IOExceptions.  Is the 
driver actively broken, or is your app just slower?

Kris Jurka

In response to

Responses

pgsql-jdbc by date

Next:From: Kris JurkaDate: 2007-12-14 10:29:10
Subject: Re: how to set a PreparedStatement column of XML type in 8.3?
Previous:From: Guillaume SmetDate: 2007-12-14 09:15:41
Subject: Re: Slow query after upgrades

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