Includes enhancements to effectively implement the divide and conquer strategy, including native logical replication, declarative table partitioning, and improved query parallelism. More on what’s new here.

GitLab is a popular git repository host, and this is an in-depth look at the challenges faced scaling their Postgres setup.

In this report we explore and definitively answer whether MySQL or PostgreSQL is truly faster than the other.

A rich variety of talks from the recent Postgres conference, including a guide to upgrading Postgres, tuning Postgres for high write workloads, and securing Postgres.

Transition relations are row sets that include all of the rows inserted, deleted, or modified by the current SQL statement, and are used in triggers to see a view of what the statement did.

Postgres now has a monitoring role that can be used for external monitoring tools. There’s also now an easy way to check B-tree indexes for corruption.

The popular open source management/admin tool now supports Postgres 10 and is faster.

Using the PostgreSQL search functionality that was introduced in Django 1.10 to implement full-text search.

Postgres keeps a lot of details about its data and usage patterns under the covers. In this talk, the author of pghero looks at how Postgres could start to self index with such data.

Dashboards are great for your users, except when they’re slow. This post walks through an approach to rollup your data to provide more performant dashboards across larger data.

EDB Postgres Training e-Subscriptions simplify how you purchase and consume training. Get unlimited access.

An extension which adds hypothetical indexes so you can see if Postgres would use them for your queries. Now updated for Postgres 10.