Re: Upgraded to 8.2.3 --- still having performance issues - Mailing list pgsql-performance

From Tom Lane
Subject Re: Upgraded to 8.2.3 --- still having performance issues
Date
Msg-id 5279.1172683250@sss.pgh.pa.us
Whole thread Raw
In response to Upgraded to 8.2.3 --- still having performance issues  (Carlos Moreno <moreno_pg@mochima.com>)
Responses Re: Upgraded to 8.2.3 --- still having performance issues
Re: Upgraded to 8.2.3 --- still having performance issues
List pgsql-performance
Carlos Moreno <moreno_pg@mochima.com> 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:

Previous
From: Carlos Moreno
Date:
Subject: Upgraded to 8.2.3 --- still having performance issues
Next
From: Carlos Moreno
Date:
Subject: Re: Upgraded to 8.2.3 --- still having performance issues