Re: index for inet column

2022-07-07 Thread Tom Lane
Zhihong Yu writes: > 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 ? As far as Postgres is concerned, inet is a scalar type: it has a linear sort order, and there aren't many o

Re: index for inet column

2022-07-07 Thread Christoph Moench-Tegeder
## Zhihong Yu (z...@yugabyte.com): > 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. Why not use btree? The common operations are quite supported wit

index for inet column

2022-07-07 Thread Zhihong Yu
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.