Although the authors claim that gin is a powerful genie, the theme of drinks has eventually won: next-generation GIN has been called RUM.
Gin stands for Generalized Inverted Index and should be considered as a genie, not a drink.
SP-GiST is suitable for structures where the space can be recursively split into non-intersecting areas. This class comprises quadtrees, k-dimensional trees (k-D trees), and radix trees.
GiST is an abbreviation of «generalized search tree». This is a balanced search tree, just like «b-tree» discussed earlier.
We will now consider B-tree, the most traditional and widely used index. This article is large, so be patient.
Now we are ready to discuss specific types of indexes. Let's start with hash index.
Let's look into the structure of the access method interface.
This series of articles is largely concerned with indexes in PostgreSQL.
Postgres Professional delegates are back from PgConf.EU 2017 - the annual European PostgreSQL conference, which took place in Warsaw on October 24-27.
| Millions of Queries per Second: PostgreSQL and MySQL’s Peaceful Battle at Today’s Demanding Workloads
This blog compares how PostgreSQL and MySQL handle millions of queries per second.
PostgreSQL 9.6 was released yesterday. This is a great release which provides to users set of outstanding new features. We are especially happy that Postgres Professional did substantial contribution to this release.
| Galy Lee at PgConf2016 Russia presented a talk «Growing acceptance of PostgreSQL in China» - Video
This talk gave an overview about the Postgres adoption in 2015 in China.
This talk covers the top ten new features that appeared in the Postgres 9.5 release. It covers some of the major focuses for post-9.5 releases.
In July 2016 in Minsk, the capital of Belarus, Postgres Professional held educational course for PostgreSQL users and administrators.
We are delighted to repost the article by Citusdata, and appreciate the recogintion of our contribution: "Special thanks to the people at Postgres Professional for contributing most of the full-text search, JSONB, and GIN index features in PostgreSQL, as well as the initial code for the Citus COPY feature"