Re: indices and cidr/inet type

Richard Welty <rwelty@averillpark.net> writes:
> what type of index is recommended when the dominant lookup on a field is
> '<networkaddress>' << ipblock

I don't think we have a suitable index type at the moment; or more
accurately, we don't have a suitable operator class.  It would be an
interesting exercise to write an inet opclass for either rtree or GiST.
I'm not sure which one would be more suitable, but probably you could
handle << with one or the other.

            regards, tom lane