Index scan on CIDR field ?

From: Margarit Nickolov <man(at)digsys(dot)bg>
To: pgsql-sql(at)postgresql(dot)org
Subject: Index scan on CIDR field ?
Date: 1999-12-29 08:52:49
Message-ID: 199912290852.KAA19954@school.digsys.bg
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers 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-hackers by date

  From Date Subject
Next Message Bruce Momjian 1999-12-29 10:12:55 Re: [HACKERS] Index Puzzle for you
Previous Message Kristofer Munn 1999-12-29 07:10:36 Re: [HACKERS] Index Puzzle for you

Browse pgsql-sql by date

  From Date Subject
Next Message D. Duccini 1999-12-29 14:52:19 Re: [NOVICE] Index scan on CIDR field ?
Previous Message Margarit Nickolov 1999-12-29 08:46:27 Index scan on CIDR field ?