The conference gathered about 100 people, including PostgreSQL developers, DBA and customers from all over the world.
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.