From 6eb9c5a5657d1fe77b55cc261450f3538d35a94d Mon Sep 17 00:00:00 2001 From: Daniel Baumann Date: Sat, 4 May 2024 14:19:15 +0200 Subject: Adding upstream version 13.4. Signed-off-by: Daniel Baumann --- doc/src/sgml/html/btree-gin.html | 38 ++++++++++++++++++++++++++++++++++++++ 1 file changed, 38 insertions(+) create mode 100644 doc/src/sgml/html/btree-gin.html (limited to 'doc/src/sgml/html/btree-gin.html') diff --git a/doc/src/sgml/html/btree-gin.html b/doc/src/sgml/html/btree-gin.html new file mode 100644 index 0000000..98a09cc --- /dev/null +++ b/doc/src/sgml/html/btree-gin.html @@ -0,0 +1,38 @@ + +F.6. btree_gin
F.6. btree_gin
Prev UpAppendix F. Additional Supplied ModulesHome Next

F.6. btree_gin

F.6.1. Example Usage
F.6.2. Authors

+ btree_gin provides sample GIN operator classes that + implement B-tree equivalent behavior for the data types + int2, int4, int8, float4, + float8, timestamp with time zone, + timestamp without time zone, time with time zone, + time without time zone, date, interval, + oid, money, "char", + varchar, text, bytea, bit, + varbit, macaddr, macaddr8, inet, + cidr, uuid, name, bool, + bpchar, and all enum types. +

+ In general, these operator classes will not outperform the equivalent + standard B-tree index methods, and they lack one major feature of the + standard B-tree code: the ability to enforce uniqueness. However, + they are useful for GIN testing and as a base for developing other + GIN operator classes. Also, for queries that test both a GIN-indexable + column and a B-tree-indexable column, it might be more efficient to create + a multicolumn GIN index that uses one of these operator classes than to create + two separate indexes that would have to be combined via bitmap ANDing. +

+ This module is considered “trusted”, that is, it can be + installed by non-superusers who have CREATE privilege + on the current database. +

F.6.1. Example Usage

+CREATE TABLE test (a int4);
+-- create index
+CREATE INDEX testidx ON test USING GIN (a);
+-- query
+SELECT * FROM test WHERE a < 10;
+

F.6.2. Authors

+ Teodor Sigaev () and + Oleg Bartunov (). See + http://www.sai.msu.su/~megera/oddmuse/index.cgi/Gin + for additional information. +

Prev Up Next
F.5. bloom Home F.7. btree_gist
\ No newline at end of file -- cgit v1.2.3