select like and indexes - Mailing list pgsql-general

From William N. Zanatta
Subject select like and indexes
Date
Msg-id 3E2C3BF0.4010804@veritel.com.br
Whole thread Raw
Responses Re: select like and indexes
List pgsql-general
Hi,

   I'm quite new to postgresql. I need some help to understand some of
'how it works'.

   I have a table with aprox. 1 million tuples (row == tuple ??) and
I've created an index on a column 'ip' in my table.

   Well the question is: when I do,

     explain analyze select * from tbl_xxxx where ip like '200%';

   why PG doesn't use Index Scan method? why does it uses sequential
scan in place?


   Thank you,

william


pgsql-general by date:

Previous
From: Andrew Sullivan
Date:
Subject: Re: Is there a good way to make the database server send e-mail?
Next
From: "Chris Boget"
Date:
Subject: Re: Altering a table - positioning new columns