Top "Gist-index" questions

In computing, GiST or Generalized Search Tree, is a data structure and API that can be used to build a variety of disk-based search trees.

PostgreSQL index not used for query on IP ranges

I'm using PostgreSQL 9.2 and have a table of IP ranges. Here's the SQL: CREATE TABLE ips ( id serial NOT NULL, …

Read More
postgresql indexing database-design range gist-index
What's the difference between B-Tree and GiST index methods (in PostgreSQL)?

I have been working on optimizing my Postgres databases recently, and traditionally, I've only ever use B-Tree indexes. However, I …

Read More
postgresql indexing b-tree gist-index