| From: | Richard Welty <rwelty(at)averillpark(dot)net> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | indices and cidr/inet type |
| Date: | 2003-08-05 17:35:58 |
| Message-ID: | E19k5j4-0003s2-Vg@skipper.averillpark.net |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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(at)averillpark(dot)net
Averill Park Networking 518-573-7592
Java, PHP, PostgreSQL, Unix, Linux, IP Network Engineering, Security
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Williams, Travis L, NPONS | 2003-08-05 17:48:16 | multiple insert into's (may be NEWBIE question) |
| Previous Message | scott.marlowe | 2003-08-05 17:00:49 | Re: plPHP -- sort of an announcement.. but not commercial |