"Tim Jones" <[EMAIL PROTECTED]> writes: > Why is postgres using a sequential scan and not the index what > parameters do I need to adjust
You probably initialized the AIX database in a non-C locale. See the manual concerning LIKE index optimizations. regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings