Efficient Use of PostgreSQL Indexes

https://devcenter.heroku.com/articles/postgresql-indexes

by craigkerstiens • 14 years ago

4 1 14 years ago

devcenter.heroku.com

nierman• 14 years ago

Using gist indices for exclusion constraints (added in pg 9.0) can be pretty useful also.

The Postgres docs show a simple example that enforces the constraint "no two rows in the table contain overlapping circles" (&& is the overlaps operator for geometric types):

  CREATE TABLE circles (
    c circle,
    EXCLUDE USING gist (c WITH &&)
  );

http://www.postgresql.org/docs/9.1/static/ddl-constraints.ht...

Efficient Use of PostgreSQL Indexes

Related Stories