mmiranda@xxxxxxxxxxxxxxxxx writes: > Hi, iam running postgresql on two identical dl380 2.4 Xeon with 3gb RAM, i > have recently upgraded one of then from redhat 7.3 (kernel 2.4) to gentoo > (kernel 2.6), at the same time i upgraded postgres from 7.3 to 8.1, im very > disapointed, all the querys are 20-25% slower using the new versions, the > following setting are the same in postgresql.conf You might have forgotten to redo vacuum/analyze after reloading your data ... regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend
