La distribution du noyau PostgreSQL™ inclut la classe d'opérateur BRIN montrée dans Tableau 65.1, « Classe d'opérateur BRIN intégrée ».
L'opérateur de classe minmax stocke les valeurs minimale et maximale apparaissant dans l'intervalle de la colonne indexée. L'opérateur de classe inclusion stocke une valeur qui est incluse dans les valeurs contenues dans l'intervalle de la colonne indexée.
Tableau 65.1. Classe d'opérateur BRIN intégrée
| Nom | Type de données indexées | Opérateurs indexables |
|---|---|---|
| abstime_minmax_ops | abstime | < <= = >= > |
| int8_minmax_ops | bigint | < <= = >= > |
| bit_minmax_ops | bit | < <= = >= > |
| varbit_minmax_ops | bit varying | < <= = >= > |
| box_inclusion_ops | box | << &< && &> >> ~= @> <@ &<| <<| |>> |&> |
| bytea_minmax_ops | bytea | < <= = >= > |
| bpchar_minmax_ops | character | < <= = >= > |
| char_minmax_ops | "char" | < <= = >= > |
| date_minmax_ops | date | < <= = >= > |
| float8_minmax_ops | double precision | < <= = >= > |
| inet_minmax_ops | inet | < <= = >= > |
| network_inclusion_ops | inet | && >>= <<= = >> << |
| int4_minmax_ops | integer | < <= = >= > |
| interval_minmax_ops | interval | < <= = >= > |
| macaddr_minmax_ops | macaddr | < <= = >= > |
| macaddr8_minmax_ops | macaddr8 | < <= = >= > |
| name_minmax_ops | name | < <= = >= > |
| numeric_minmax_ops | numeric | < <= = >= > |
| pg_lsn_minmax_ops | pg_lsn | < <= = >= > |
| oid_minmax_ops | oid | < <= = >= > |
| range_inclusion_ops | tout type intervalle | << &< && &> >> @> <@ -|- = < <= = > >= |
| float4_minmax_ops | real | < <= = >= > |
| reltime_minmax_ops | reltime | < <= = >= > |
| int2_minmax_ops | smallint | < <= = >= > |
| text_minmax_ops | text | < <= = >= > |
| tid_minmax_ops | tid | < <= = >= > |
| timestamp_minmax_ops | timestamp without time zone | < <= = >= > |
| timestamptz_minmax_ops | timestamp with time zone | < <= = >= > |
| time_minmax_ops | time without time zone | < <= = >= > |
| timetz_minmax_ops | time with time zone | < <= = >= > |
| uuid_minmax_ops | uuid | < <= = >= > |
Index BRIN
