-----Original Message----- From: pgsql-performance-owner@postgresql.org [mailto:pgsql-performance-owner@postgresql.org] On Behalf Of Sriram Dandapani Sent: Tuesday, April 25, 2006 12:08 PM To: Pgsql-Performance (E-mail) Subject: [PERFORM] planner not using index for like operator
For the query
Select col1 from table1
Where col1 like ‘172.%’
The table has 133 million unique ip addresses. Col1 is indexed.