Re: [SQL] Index selection on a large table

2000-07-25 Thread Tom Lane
"Michael Richards" <[EMAIL PROTECTED]> writes: > The following query yeilds the questionable query plan: > explain select * from logins where ip='38.30.141.44'; > NOTICE: QUERY PLAN: > Seq Scan on logins (cost=0.00..25248.51 rows=11602 width=48) If there really were 11602 matching rows, the se

[SQL] Index selection on a large table

2000-07-25 Thread Michael Richards
Hi. I believe this to be a bug, but I am submitting it to the SQL list as well in the case I overlooked something. I'm running Postgres 7.0.2 on FreeBSD 4.0-STABLE/Intel compiled with [gcc version 2.95.2 19991024 (release)] I've got this interesting problem where the query plan is not what