Issue 316 - Considering combined vs separate indexes in Postgres (9)

pglogical 2.2.2 Released — pglogical is an extension-based logical replication system that serves as an efficient alternative to physical replication.

An Introduction to Parallelism in Postgres — Some interesting digging into what parallelism really means in modern versions of Postgres, including how parallel sequential scans, aggregations, and B-tree scans speed things up.

Combined Indexes vs. Separate Indexes — A common question when it comes to designing relational databases relates to when composite indexes (indexes that involve multiple columns) make more sense than single column indexes. Hans-Jürgen looks at some scenarios in Postgres.

A Dive into PostgreSQL on AWS Aurora — Amazon Aurora boasts PostgreSQL compatibility but what does it really offer, how is it to use, and what are its limitations? Viorel Tabara takes a look.

Is SQL on DNA The Next Frontier for Databases? — An EU initiative funds far out technology ideas, one of which is the idea of storing data within synthesized DNA. It’s still expensive to do but progress has been made and there are academic papers and demos (based on Postgres) ready to go.

Comparing jsquery vs SQL/JSON for Querying JSON — Native support for SQL/JSON is coming to Postgres 12 and will offer a standardized way to query JSON data stored within Postgres’s JSONB columns. jsquery, on the other hand, offered a similar query language in an extension from Postgres 9.4 onward. How do they compare?

'Big Data' with Postgres and Apache Spark — Spark is a popular open source analytics engine for big data processing and if you’ve found it a little opaque till now, here’s the basic steps of getting it to interact with a Postgres database.

Implementing Constraint Exclusion for Faster Query Performance — A look at how Timescale (who create a time-series focused extension for PostgreSQL) leveraged the foundation of PostgreSQL and extended its capabilities to improve performance.