indices and cidr/inet type - Mailing list pgsql-general

From Richard Welty
Subject indices and cidr/inet type
Date
Msg-id E19k5j4-0003s2-Vg@skipper.averillpark.net
Whole thread Raw
Responses Re: indices and cidr/inet type  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
in looking over the section of the users manual on indices, i see that
R-Tree indices are recommended for <<, but this advice is clearly tied to
the geometric interpretation of << ("to the left of") rather than the
network interpretation ("is contained in").

what type of index is recommended when the dominant lookup on a field is

'<networkaddress>' << ipblock

where the ipblock column is of type cidr?

thanks,
  richard
--
Richard Welty                                         rwelty@averillpark.net
Averill Park Networking                                         518-573-7592
    Java, PHP, PostgreSQL, Unix, Linux, IP Network Engineering, Security

pgsql-general by date:

Previous
From: "scott.marlowe"
Date:
Subject: Re: plPHP -- sort of an announcement.. but not commercial
Next
From: "Williams, Travis L, NPONS"
Date:
Subject: multiple insert into's (may be NEWBIE question)