---
title: "PostgreSQL specific model indexes"
version: 2.2
locale: pt-br
source: https://docs.djangoproject.com/pt-br/2.2/ref/contrib/postgres/indexes/
canonical: https://djangodocs.dev/pt-br/2.2/ref/contrib/postgres/indexes/
---
# PostgreSQL specific model indexes

The following are PostgreSQL specific [indexes](/pt-br/2.2/ref/models/indexes/)
available from the `django.contrib.postgres.indexes` module.

## `BrinIndex`

#### `class BrinIndex(autosummarize=None, pages_per_range=None, **options)`

Creates a [BRIN index](https://www.postgresql.org/docs/current/brin-intro.html).

Set the `autosummarize` parameter to `True` to enable [automatic
summarization](https://www.postgresql.org/docs/current/brin-intro.html#BRIN-OPERATION) to be performed by autovacuum.

The `pages_per_range` argument takes a positive integer.

> **Changed in Django 2.2**
>
> The `autosummarize` parameter was added.

## `BTreeIndex`

#### `class BTreeIndex(fillfactor=None, **options)`

> **New in Django 2.2**

Creates a B-Tree index.

Provide an integer value from 10 to 100 to the [fillfactor](https://www.postgresql.org/docs/current/sql-createindex.html#SQL-CREATEINDEX-STORAGE-PARAMETERS) parameter to
tune how packed the index pages will be. PostgreSQL’s default is 90.

## `GinIndex`

#### `class GinIndex(fastupdate=None, gin_pending_list_limit=None, **options)`

Creates a [gin index](https://www.postgresql.org/docs/current/gin.html).

To use this index on data types not in the [built-in operator classes](https://www.postgresql.org/docs/current/gin-builtin-opclasses.html),
you need to activate the [btree\_gin extension](https://www.postgresql.org/docs/current/btree-gin.html) on
PostgreSQL. You can install it using the
[`BtreeGinExtension`](/pt-br/2.2/ref/contrib/postgres/operations/#django.contrib.postgres.operations.BtreeGinExtension) migration
operation.

Set the `fastupdate` parameter to `False` to disable the [GIN Fast
Update Technique](https://www.postgresql.org/docs/current/gin-implementation.html#GIN-FAST-UPDATE) that’s enabled by default in PostgreSQL.

Provide an integer number of bytes to the [gin\_pending\_list\_limit](https://www.postgresql.org/docs/current/runtime-config-client.html#GUC-GIN-PENDING-LIST-LIMIT) parameter
to tune the maximum size of the GIN pending list which is used when
`fastupdate` is enabled. This parameter requires PostgreSQL ≥ 9.5.

## `GistIndex`

#### `class GistIndex(buffering=None, fillfactor=None, **options)`

Creates a [GiST index](https://www.postgresql.org/docs/current/gist.html). These indexes are
automatically created on spatial fields with [`spatial_index=True`](/pt-br/2.2/ref/contrib/gis/model-api/#django.contrib.gis.db.models.BaseSpatialField.spatial_index). They’re
also useful on other types, such as
[`HStoreField`](/pt-br/2.2/ref/contrib/postgres/fields/#django.contrib.postgres.fields.HStoreField) or the [range
fields](/pt-br/2.2/ref/contrib/postgres/fields/#range-fields).

To use this index on data types not in the built-in [gist operator classes](https://www.postgresql.org/docs/current/gist-builtin-opclasses.html),
you need to activate the [btree\_gist extension](https://www.postgresql.org/docs/current/btree-gist.html) on PostgreSQL.
You can install it using the
[`BtreeGistExtension`](/pt-br/2.2/ref/contrib/postgres/operations/#django.contrib.postgres.operations.BtreeGistExtension) migration
operation.

Set the `buffering` parameter to `True` or `False` to manually enable
or disable [buffering build](https://www.postgresql.org/docs/current/gist-implementation.html#GIST-BUFFERING-BUILD) of the index.

Provide an integer value from 10 to 100 to the [fillfactor](https://www.postgresql.org/docs/current/sql-createindex.html#SQL-CREATEINDEX-STORAGE-PARAMETERS) parameter to
tune how packed the index pages will be. PostgreSQL’s default is 90.

## `HashIndex`

#### `class HashIndex(fillfactor=None, **options)`

> **New in Django 2.2**

Creates a hash index.

Provide an integer value from 10 to 100 to the [fillfactor](https://www.postgresql.org/docs/current/sql-createindex.html#SQL-CREATEINDEX-STORAGE-PARAMETERS) parameter to
tune how packed the index pages will be. PostgreSQL’s default is 90.

> **Use this index only on PostgreSQL 10 and later**
>
> Hash indexes have been available in PostgreSQL for a long time, but
> they suffer from a number of data integrity issues in older versions.

## `SpGistIndex`

#### `class SpGistIndex(fillfactor=None, **options)`

> **New in Django 2.2**

Creates an [SP-GiST index](https://www.postgresql.org/docs/current/spgist.html).

Provide an integer value from 10 to 100 to the [fillfactor](https://www.postgresql.org/docs/current/sql-createindex.html#SQL-CREATEINDEX-STORAGE-PARAMETERS) parameter to
tune how packed the index pages will be. PostgreSQL’s default is 90.