#316 — July 31, 2019

Read on the Web

Postgres Weekly

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.

Ibrar Ahmed

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.

Hans-Jürgen Schönig

An Overview of Sharding in PostgreSQL — Learn about the new features in PostgreSQL that allow the deployment of simple shards.

Percona sponsor

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.

Severalnines

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.

George Anadiotis (ZDNet)

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?

Thom Brown

Because Your Data Is Your Business — PGX provides complete PostgreSQL support, from emergency services through daily operational support, to strategic planning. We’re here for your data ops.

PostgreSQL Experts, Inc sponsor

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

Sebastian Insausti

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.

Sven Klemm

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

2ndQuadrant

supported by

💡 Tip of the Week

A way to customize how NULL values are ordered
Kindly supplied by Jonathan Reinink via Twitter

One of my favourite smaller features of PostgreSQL is ordering data with NULL values last (or first). You can simply add NULLS LAST or NULLS FIRST after the direction (ASC/DESC).

This allows you to always keep NULL values last, regardless of the direction you're sorting.

The Tip of the Week is sponsored by Datadog. Monitor your Postgres databases, cloud services, web servers, containers, and servlets all in one place with Datadog. Try it free.

🗓 Upcoming Postgres Events