How to create a Gin index on a geometry column in Postgresql?

Question

According to pgAdmin 4 4.21 documentation » Creating or Modifying a Table »

Select gin to create a GIN index. A GIN index may improve performance when managing two-dimensional geometric data types and nearest-neighbor searches

We should create a Gin index for geometric column if we intend to use Nearest-neighbor searches, Which I do!

However, when defining Gin index it asks for Operator Class and there are two options there (jsonb_path_obs and gin_int_ops) but none of them works with Geometry type.

Could someone please tell me how to create a Gin index on a Geometry type column?

P.S by geometry I mean PostGIS's geometry column type

jjanes · Accepted Answer · 2020-08-11 15:44:21Z

5

Please link to the thing you are quoting so we don't have to go searching for it.

That looks like a bug in the pgadmin4 docs. They seem to have the GIN and GiST labels reversed in those descriptions. GIN supports multiple keys better than GiST does, but doesn't support nearest-neighbor or spatial. You want a GiST index.

answered Aug 11, 2020 at 15:44

jjanes

44.9k5 gold badges39 silver badges48 bronze badges

Sign up to request clarification or add additional context in comments.

4 Comments

Iman Rosstin Over a year ago

Sorry but the documentation was on 127.0.0.1 so I couldn't provide link. Yes, I should have searched and provide a link on the internet. I will edit my question and add your link to it.

Iman Rosstin Over a year ago

Thanks by the way.(also +1)

jjanes Over a year ago

OK, I see. I've fled a doc bug for this, redmine.postgresql.org/issues/5734.

Iman Rosstin Over a year ago

That would be great as new users like me could really be misled

Collectives™ on Stack Overflow

How to create a Gin index on a geometry column in Postgresql?

1 Answer 1

4 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

4 Comments

Your Answer

Sign up or log in

Post as a guest

Related