Stefano Bargioni <[EMAIL PROTECTED]> writes:
> SELECT FROM t WHERE a='my string'; works very fast. The same select
> made on b is very slow (2 or 3 seconds), as if no index exists for
> column b.
What does EXPLAIN say about the two queries?
regards, tom lane
I defined a table with two indexed text columns, a and b, of variable length.
This table contains 287195 rows.
SELECT FROM t WHERE a='my string'; works very fast. The same select made on b is very
slow (2 or 3 seconds), as if no index exists for column b.
I'd like to know why. Note that b contain
