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

From Tom Lane
Subject Re: indices and cidr/inet type
Date
Msg-id 11707.1060110540@sss.pgh.pa.us
Whole thread Raw
In response to indices and cidr/inet type  (Richard Welty <rwelty@averillpark.net>)
Responses Re: indices and cidr/inet type  (Richard Welty <rwelty@averillpark.net>)
List pgsql-general
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

pgsql-general by date:

Previous
From: Justin Tocci
Date:
Subject: INSERT RULE QUERY ORDER
Next
From: Tom Lane
Date:
Subject: Re: INSERT RULE QUERY ORDER