| Indexes in PostgreSQL — 8 (RUM)

Although the authors claim that gin is a powerful genie, the theme of drinks has eventually won: next-generation GIN has been called RUM.

| Indexes in PostgreSQL — 7 (GIN)

Gin stands for Generalized Inverted Index and should be considered as a genie, not a drink.

| Indexes in PostgreSQL — 6 (SP-GiST)

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.

| Indexes in PostgreSQL — 5 (GiST)

GiST is an abbreviation of «generalized search tree». This is a balanced search tree, just like «b-tree» discussed earlier.

| Indexes in PostgreSQL — 4 (Btree)

We will now consider B-tree, the most traditional and widely used index. This article is large, so be patient.

| Indexes in PostgreSQL — 3 (Hash)

Now we are ready to discuss specific types of indexes. Let's start with hash index.

| Indexes in PostgreSQL — 2

Let's look into the structure of the access method interface.

| Indexes in PostgreSQL — 1

This series of articles is largely concerned with indexes in PostgreSQL.

| Warsaw PgConf.EU 2017 has finished

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 is Released: Contribution of Postgres Professional

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.

| Bruce Momjian at PgConf2016 Russia with talk «Postgres Going in Multiple Directions» - Video

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.

| DBA1: Free PostgreSQL Course In Minsk

In July 2016 in Minsk, the capital of Belarus, Postgres Professional held educational course for PostgreSQL users and administrators.

| Scalable Real-time Product Search using PostgreSQL with Citus

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"