On Tue, 2 Oct 2001, [euc-kr] Jeong Jaeick, Á¤ÀçÀÍ wrote:
> select * from pgsql_bbs where topic = 'qna' and deleted < 2
> order by gid desc, pos asc limit 20, 0;
>
> But this query is not using index!
>
> The next is result of explain of this query:
>
> dsn=# explain select * from pgsql_bbs where topic = 'qna' and deleted < 2
> dsn-# order by gid desc, pos asc limit 20, 0;
> NOTICE: QUERY PLAN:
>
> Limit (cost=15.71..15.71 rows=11 width=245)
> -> Sort (cost=15.71..15.71 rows=11 width=245)
> -> Index Scan using pgsql_topic_deleted on pgsql_bbs (cost=0.00..15.51
>rows=11 width=245)
It appears to be using the topic_deleted index according to this
explain output.
How many rows actually have topic='qna' and deleted<2?
---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
