Search: [GiST] - Anayrat links

The Wide World of GiST Indexes - Simple Talk

PostgreSQL · not_read · GiST

March 30, 2025 at 11:11:15 AM GMT+2 * · permalink

https://www.red-gate.com/simple-talk/databases/postgresql/the-wide-world-of-gist-indexes/

GitHub - x4m/gist2023: Materials for PGCon-2023 talk "GiST news and prospects"

PostgreSQL · GiST · Internal · pgcon2023

June 5, 2023 at 3:38:50 PM GMT+2 * · permalink

https://github.com/x4m/gist2023

PostgreSQL unique constraint, but NULL conflicts with everything

PostgreSQL · constraint · Exclusion_constraint · GiST

February 8, 2023 at 2:34:37 PM GMT+1 * · permalink

https://www.cybertec-postgresql.com/en/unique-constraint-null-conflicts-with-everything/

Optimizing Postgres Text Search with Trigrams - Alex Klibisz

PostgreSQL · trgm · GiST

March 4, 2022 at 2:55:01 PM GMT+1 * · permalink

https://alexklibisz.com/2022/02/18/optimizing-postgres-trigram-search.html

Tricks for Faster Spatial Indexes

PostgreSQL · Postgis · GiST · performance

December 4, 2021 at 5:06:13 PM GMT+1 * · permalink

https://blog.crunchydata.com/blog/tricks-for-faster-spatial-indexes

Do you need a Full-Text Search in PostgreSQL ?

PostgreSQL · RUM · FTS · GiST · GIN

September 15, 2021 at 11:39:54 AM GMT+2 * · permalink

https://www.postgresql.eu/events/pgconfeu2018/sessions/session/2116/slides/137/pgconf.eu-2018-fts.pdf

(The Many) Spatial Indexes of PostGIS

GiST · SP-GIST · Postgis · PostgreSQL · index · BRIN

May 5, 2021 at 11:05:38 PM GMT+2 * · permalink

https://blog.crunchydata.com/blog/the-many-spatial-indexes-of-postgis

Spatial Indexing for OSM in PostGIS

Postgis · PostgreSQL · GiST · SP-GIST · BRIN · index

April 5, 2021 at 8:04:41 PM GMT+2 * · permalink

https://slides.com/fxku/sotm19/fullscreen

Indexes in PostgreSQL — 5 (GiST) / Postgres Professional corporate blog / Habr

GiST · index · PostgreSQL · Internal

April 19, 2019 at 9:42:22 AM GMT+2 * · permalink

https://habr.com/en/company/postgrespro/blog/444742/

Look It Up: Practical PostgreSQL Indexing

PostgreSQL · index · GiST · GIN · BRIN · Btree

March 20, 2019 at 3:54:27 PM GMT+1 * · permalink

https://thebuild.com/presentations/look-it-up-pgday-nordic-2019.pdf

Won’t You Be My Neighbor? Quickly Finding Who is Nearby

PostgreSQL · GiST · KNN

October 11, 2018 at 1:47:21 PM GMT+2 * · permalink

https://info.crunchydata.com/blog/wont-you-be-my-neighbor-quickly-finding-who-is-nearby

Geolocation with PostgreSQL

PostgreSQL · ip4r · GiST

August 26, 2018 at 4:22:58 PM GMT+2 * · permalink

https://tapoueh.org/blog/2018/08/geolocation-with-postgresql/

PostgreSQL Data Types: Point

PostgreSQL · types · sql · GiST

May 7, 2018 at 2:25:06 PM GMT+2 * · permalink

https://tapoueh.org/blog/2018/05/postgresql-data-types-point/

Principles and Applications of the Index Types Supported by PostgreSQL

PostgreSQL · index · GiST · SP-GIST · Btree · GIN · BRIN · Bloom

January 28, 2018 at 5:59:36 PM GMT+1 * · permalink

https://medium.com/@Alibaba_Cloud/principles-and-applications-of-the-index-types-supported-by-postgresql-481f59bab67d

Trying to Represent a Tree Structure Using Postgres - Pat Shaughnessy

PostgreSQL · SQL · tree · LTREE · GiST

December 12, 2017 at 3:55:31 PM GMT+1 * · permalink

http://patshaughnessy.net/2017/12/11/trying-to-represent-a-tree-structure-using-postgres

Search Trees. - ppt download

GiST · SP-GIST · index · not_read · PostgreSQL

October 18, 2017 at 5:51:03 PM GMT+2 * · permalink

http://slideplayer.com/slide/4748666/

Retrieving Data from Disk – Access Methods Zachary G. Ives University of Pennsylvania CIS 650 – Implementing Data Management Systems January 19, 2005 Slides. - ppt download

GiST · index · not_read · SP-GIST · PostgreSQL

October 18, 2017 at 5:50:45 PM GMT+2 * · permalink

http://slideplayer.com/slide/5063712/

A tour of Postgres Index Types

PostgreSQL · index · GiST · SP-GIST · GIN · Btree · Hash

October 17, 2017 at 10:05:05 PM GMT+2 * · permalink

https://www.citusdata.com/blog/2017/10/17/tour-of-postgres-index-types/

GiST support in PostgreSQL

PostgreSQL · GiST

June 6, 2017 at 1:16:42 PM GMT+2 * · permalink

http://www.sai.msu.su/~megera/postgres/gist/