Silke Trissl <[EMAIL PROTECTED]> writes: > I found out, that the change of the operator from '~*' to '=' for the > item.description brought a great boost in performance (425 secs to 1 > sec!), but not in cost (Query plans at the end).
The main problem seems to be bad estimation of the number of rows extracted from the item table. Have you ANALYZEd that table lately? regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings