Re: Slow query after upgrades

Albert,

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