Upgraded from 7.4 to 8.1.4 QUERIES NOW SLOW!!!

Hello all,

Old servers that housed 7.4 performed better than 8.1.4 version...are there
any MAJOR performance hits with this version???

I set the postgresql.conf setting to equal that of 7.4 and queries still run
SLOW on 8.1.4...

I have perform maintenance tonight on the 8.1.4 server - any ideas what
actions I should take???

default stats set to 50 (in postgresql.conf)

1) Restart instance
2) Dump \ reload database
3) vacuum analyze
4) rebuild index database

I keep doing these same steps and nothing seems to work...I've read where
some are saying to VACUUM several times - then reindex (???)

Can someone tell me what they do during a NORMAL maintenance window on their
servers???

All this is NEW to me.

Thanks,
Michelle.
--
View this message in context: http://www.nabble.com/Upgraded-from-7.4-to-8.1.4-QUERIES-NOW-SLOW%21%21%21-tf4489502.html#a12803859
Sent from the PostgreSQL - performance mailing list archive at Nabble.com.