PostgreSQL

| 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.

| 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.

| 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"

| Monitoring Wait Events in PostgreSQL 9.6

Recently Robert Haas has committed a patch which allows seeing some more detailed information about current wait event of the process. In particular, user will be able to see if process is waiting for heavyweight lock, lightweight lock (either individual or tranche) or buffer pin. The full list of wait events is available in the documentation. Hopefully, it will be more wait events in further releases.

| Postgres developers (retrospective in pictures)

Oleg Bartunov: Today I have feeling, that our developers community needs some nostalgia.

| Beta-release of pg_pathman partitioning extension

pg_pathman is distributed as PostgreSQL 9.5 extension and available at github

| Scaling PostgreSQL at multicore Power8

Recently, we got  access to a big server: IBM 9119-MHE with 8 CPUs * 8 cores * 8 threads. We decided to take advantage of this and investigate the read scalability of postgres (pgbench -S) at this server.