Re: Upgraded to 8.2.3 --- still having performance issues

From: Tom Lane
Subject: Re: Upgraded to 8.2.3 --- still having performance issues
Date: ,
Msg-id: 5279.1172683250@sss.pgh.pa.us
(view: Whole thread, Raw)
In response to: Upgraded to 8.2.3 --- still having performance issues  (Carlos Moreno)
Responses: Re: Upgraded to 8.2.3 --- still having performance issues  (Carlos Moreno)
Re: Upgraded to 8.2.3 --- still having performance issues  (Carlos Moreno)
List: pgsql-performance

Tree view

Upgraded to 8.2.3 --- still having performance issues  (Carlos Moreno, )
 Re: Upgraded to 8.2.3 --- still having performance issues  (Tom Lane, )
  Re: Upgraded to 8.2.3 --- still having performance issues  (Carlos Moreno, )
   Re: Upgraded to 8.2.3 --- still having performance issues  (Rodrigo Gonzalez, )
    Re: Upgraded to 8.2.3 --- still having performance issues  (Carlos Moreno, )
     Re: Upgraded to 8.2.3 --- still having performance issues  (Carlos Moreno, )
  Re: Upgraded to 8.2.3 --- still having performance issues  (Carlos Moreno, )
 Re: Upgraded to 8.2.3 --- still having performance issues  (Dennis Bjorklund, )

Carlos Moreno <> writes:
> I would have expected a mind-blowing increase in responsiveness and
> overall performance.  However, that's not the case --- if I didn't know
> better, I'd probably tend to say that it is indeed the opposite
> (performance seems to have deteriorated)

Did you remember to re-ANALYZE everything after loading up the new
database?  That's a frequent gotcha ...

            regards, tom lane


pgsql-performance by date:

From: Carlos Moreno
Date:
Subject: Re: Upgraded to 8.2.3 --- still having performance issues
From: Bruno Wolff III
Date:
Subject: Re: Two hard drives --- what to do with them?