| Postgres Professional took part in the PGIBZ conference on the beaches of Ibiza
The conference gathered about 100 people, including PostgreSQL developers, DBA and customers from all over the world.
| 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.
-
-
Thems