Constantin Teodorescu <teo(at)flex(dot)ro> writes:> Was it something related with LC_COLLATE or LC_CTYPE?
LC_COLLATE='en_US' disables LIKE index optimizations. You mustuse C locale to make that work.
regards, tom lane