> Maybe it will be useful for you! Or maybe there is already some built-in way
> to treat cidr columns like ranges?
There is GiST operator class since version 9.4 and SP-GiST operator
class on version 9.6:
CREATE INDEX ON tracked_ip_address USING gist (ip_address inet_ops);
CREATE INDEX ON track
> On Mar 1, 2017, at 8:39 AM, jonathan vanasco wrote:
>
>
> I have to store/search some IP data in Postgres 9.6 and am second-guessing my
> storage options.
>
>
> The types of searching I'm doing:
[...]
>
> 2. on tracked_ip_block, i search/join against the tracked_ip_address to
>
On 03/01/2017 08:39 AM, jonathan vanasco wrote:
I have to store/search some IP data in Postgres 9.6 and am second-guessing my
storage options.
Would anyone mind giving this a quick look for me?
Right now I have two tables, and am just using cidr for both:
Hi Jonathan,
CIDR seems like a bet
