[EMAIL PROTECTED] writes: > so, i am wondering if analyze also does a table scan,
It does not --- it does a statistical sampling, and it's quite possible that the estimate will be badly off. regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings