Home > mailing lists

index for inet column - Mailing list pgsql-hackers

From	Zhihong Yu
Subject	index for inet column
Date	July 8, 2022 00:52:07
Msg-id	CALNJ-vSfhyd3eTdHU2XLzzhGtL2WnZ7y04S1-Se4kKcLC4d0Rw@mail.gmail.com Whole thread Raw
Responses	Re: index for inet column Re: index for inet column
List	pgsql-hackers

Hi,

I was able to create gin index on inet column in PG.

GIN is good with points/elements in sets. Is gin a good index for inet column ?

It seems gist index would be better.

Comments are welcome.

From: Andrew Dunstan
Date: 08 July 2022, 00:49:02
Subject: Re: SQL/JSON: functions

From: Christoph Moench-Tegeder
Date: 08 July 2022, 01:06:11
Subject: Re: index for inet column