Stefano Bargioni <[EMAIL PROTECTED]> writes:
>> What does EXPLAIN say about the two queries?
> ucc2=> explain select count(*) from document where xtitle='a';
> NOTICE: QUERY PLAN:
> Aggregate (cost=70.61 rows=759 width=4)
> -> Index Scan using xtitle_index on document (cost=70.61 rows=759 wi
> Stefano Bargioni 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
>
Dear Tom, thank
