Postgres Pro
Downloads
Home   >   mailing lists

Index scan on CIDR field ? - Mailing list pgsql-sql

From Margarit Nickolov
Subject Index scan on CIDR field ?
Date
Msg-id 199912290852.KAA19954@school.digsys.bg
Whole thread Raw
Responses Re: [SQL] Index scan on CIDR field ?
List pgsql-sql
Tree view 
I created index on cidr field on table with about 1 000 000 rows, made 
'vacuum analyze', but exlain told me that sequental scan is doneon query like that SELECT * FROM table WHERE
ipaddr='212.129.92.1'
 I'm using PostgreSQL 6.5.1. I need a index scan. Do I miss something ?
Margarit.

pgsql-sql by date:

Previous
From: Margarit Nickolov
Date:
Subject: Index scan on CIDR field ?
Next
From: "D. Duccini"
Date:
Subject: Re: [NOVICE] Index scan on CIDR field ?