Dave Cramer <[EMAIL PROTECTED]> writes: > after vacuum verbose analyze, I still get [a seqscan]
The other gating factor is that you have to have initdb'd in C locale. Non-C locales tend to use wild and wooly sort orders that are not compatible with what LIKE needs. regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives? http://archives.postgresql.org