Re: Very slow select

Stefano Bargioni <bargioni@usc.urbe.it> 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