Index scan on CIDR field ?

From: Margarit Nickolov <man(at)digsys(dot)bg>
To: pgsql-novice(at)postgresql(dot)org, pgsql-sql(at)postgresql(dot)org
Subject: Index scan on CIDR field ?
Date: 1999-12-29 08:46:27
Message-ID: 199912290846.KAA19677@school.digsys.bg
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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 done
on 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.

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Margarit Nickolov 1999-12-29 08:52:49 Index scan on CIDR field ?
Previous Message Jan Wieck 1999-12-29 00:46:35 Re: [SQL] Oracle sql queries