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

Re: Slow query after upgrades

From: "Guillaume Smet" <guillaume(dot)smet(at)gmail(dot)com>
To: 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 09:15:41
Message-ID: 1d4e0c10712140115v6860c52en7165ef58ddc93510@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-jdbc
Albert,

On Dec 14, 2007 9:55 AM, Albert László-Róbert
<albertlaszlorobert(at)gmail(dot)com> 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.

Did you analyze your database after upgrade?

Can you enable log_min_duration_statement to see which queries are
slower than before? You can use pgFouine to obtain an analysis of the
log file.

--
Guillaume

In response to

Responses

pgsql-jdbc by date

Next:From: Kris JurkaDate: 2007-12-14 10:24:16
Subject: Re: Slow query after upgrades
Previous:From: Albert László-RóbertDate: 2007-12-14 08:55:16
Subject: Re: Slow query after upgrades

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