Browse categories
PostgreSQL releases
- PostgreSQL 14 (dev)
- PostgreSQL 13 (latest)
- PostgreSQL 12
- PostgreSQL 11
- PostgreSQL 10
- PostgreSQL 9.6
- PostgreSQL 9.5 (EOL)

Version charts

SQL commands
System catalog tables
System catalog views
System statistics views
File system functions

Progress reporting views
Contrib modules
Storage parameters (relopts)

Useful overviews

xlog renaming in Pg 10
Online tools for PostgreSQL

Useful links

PostgreSQL documentation
PostgreSQL feature matrix
PostgreSQL versioning policy
PostgreSQL latest versions

@postgrespedia

Contents

Change history
References
Useful links
Categories
See also

btree_gin

A contrib module providing sample GIN operator classes which implement B-tree equivalent behaviour for certain datatypes

btree_gin is a contrib module providing sample GIN operator classes which implement B-tree equivalent behaviour for certain datatypes.

btree_gin was added in PostgreSQL 8.4.

Change history

PostgreSQL 13
- marked as a trusted extension (commit eb67623c)
PostgreSQL 11 (1.3)
- support for indexing BOOL, BPCHAR, NAME and UUID datatypes added (commit f4cd7102)
PostgreSQL 10 (1.2)
- support for indexing ENUM datatypes added (commit 4ad0f88c)
- support for indexing the MACADDR8 datatype added (commit c7a9fa39)
PostgreSQL 9.1 (1.0)
- converted to an extension (commit 629b3af2)
PostgreSQL 8.4
- added (commit 9151e1bb)

References

PostgreSQL documentation: btree_gin

Useful links

Joining BTree and GIN/GiST indexes - May 2014 blog article by depesz.com

Categories

See also