Received: from danbo.digsys.bg (root@danbo.digsys.bg [192.92.129.10]) by hub.org (8.9.3/8.9.3) with ESMTP id DAA16415; Wed, 29 Dec 1999 03:46:32 -0500 (EST) (envelope-from man@school.digsys.bg) Received: from school.digsys.bg (man@school.digsys.bg [193.68.6.1]) by danbo.digsys.bg (8.9.0/8.9.0) with ESMTP id KAA25612; Wed, 29 Dec 1999 10:46:27 +0200 (EET) Received: (from man@localhost) by school.digsys.bg (8.8.5/8.8.5) id KAA19677; Wed, 29 Dec 1999 10:46:27 +0200 (EET) Date: Wed, 29 Dec 1999 10:46:27 +0200 (EET) From: Margarit Nickolov Message-Id: <199912290846.KAA19677@school.digsys.bg> To: pgsql-novice@postgresql.org, pgsql-sql@postgresql.org Subject: Index scan on CIDR field ? 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.