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
