Postgres indexes and their types

CREATE INDEX index-name ON table-name (column-names);
CREATE INDEX CONCURRENTLY index-name ON table-name (column-names);
DROP INDEX index-name;

Index Types

Criteria for using different index types

<, <=, =, >=, >, BETWEEN, IN, LIKE, ~ etc.
CREATE INDEX index-name ON table-name USING GIST (column-name operator-class);

GIN index

Unique indexes

CREATE UNIQUE INDEX index-name ON table-name (column-names);

Partial indexes

--

--

--

Product Engineer at Gojek.

Love podcasts or audiobooks? Learn on the go with our new app.

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store
Asheet Bhaskar

Asheet Bhaskar

Product Engineer at Gojek.

More from Medium

SQL Injection VS Prepared Statement

The flat file in webMethods with Demo.

Ruby vs Java: Key Differences

Using JWT authentication to secure enterpriseservice communications