Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
Re: Upgraded to 8.2.3 --- still having performance issues
- From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
- To: Carlos Moreno <moreno_pg(at)mochima(dot)com>
- Cc: PostgreSQL Performance <pgsql-performance(at)postgresql(dot)org>
- Subject: Re: Upgraded to 8.2.3 --- still having performance issues
- Date: Wed, 28 Feb 2007 12:20:50 -0500
Carlos Moreno <moreno_pg(at)mochima(dot)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
- Follow-Ups:
- Re: Upgraded to 8.2.3 --- still having performance issues
- From: Carlos Moreno
- Re: Upgraded to 8.2.3 --- still having performance issues
- References:
- Upgraded to 8.2.3 --- still having performance issues
- From: Carlos Moreno
- Upgraded to 8.2.3 --- still having performance issues
- Prev by Date: Upgraded to 8.2.3 --- still having performance issues
- Next by Date: Re: Upgraded to 8.2.3 --- still having performance issues
- Previous by thread: Upgraded to 8.2.3 --- still having performance issues
- Next by thread: Re: Upgraded to 8.2.3 --- still having performance issues
- Indexes: