#309 — June 12, 2019

Read on the Web

Postgres Weekly

▶  Exploring 10 Postgres Tips and Tricks — The audio is a little telephonic as it's from a webinar, but some slides are here if you prefer. The talk itself is good, though, with Bruce digging into a variety of smaller but practical and interesting Postgres tips.

Bruce Momijan

How COPY and Bulk Loading Will Be Improved in Postgres 12 — In Postgres 12, the COPY command, commonly used to load data into Postgres quickly, will introduce a handy WHERE condition.

Hans-Jürgen Schönig

PostgreSQL Logging Best Practices — There are several reasons why you might want an audit trail of users’ activity on a PostgreSQL database, we put together some best practices to keep everyone on the same page.

strongDM sponsor

A Look at Postgres' Bloom Index Support — The last in a fantastic series of articles digging deep into each type of index that Postgres provides. This time, it’s the turn of bloom indexes which are based on bloom filters, a type of data structure that can provide very rapid membership checks but with a chance of false positives.

Egor Rogov

▶  How AWS Provides Managed PostgreSQL Databases — A high level 50 minute session that covers the history of AWS RDS and how AWS has provided managed Postgres services over the years. Covers how encryption works, instance types, replication.. basically a ‘101’ class on using Postgres with AWS.

Kevin Jernigan

How Postgres 12 Will Handle Prepared Plans — Using the same plan for prepared queries can provide a performance boost and Postgres intelligently makes a decision as to which plan to use for queries that are executed with different parameter values. Postgres 12 will let you more explicitly control what happens, however.

Hans-Jürgen Schönig

A Look at PostgreSQL's BRIN Indexes — BRIN (Block Range Index) indexes are a powerful way to accelerate sequential scans of tables where the indexed values can be grouped into ‘ranges’ of values (e.g. ZIP codes, ages, order totals).

Egor Rogov

Incremental Backup and Point-In-Time Recovery in Postgres — How to use WAL archiving for point-in-time recovery (PITR).


▶  A Deep Dive into Amazon Aurora PostgreSQL Performance Tuning — An hour long talk where the speaker promises that you will truly learn something.

James Finnerty

Why the RDMBS Is the Future of Distributed Databases — An exploration of how a distributed Postgres RDBMS can lower development costs for applications developers.


A Recursive CTE to Get Information About Partitions — A look at a rather beefy SQL query that will let you see information about all of the partitions in your database.

Luca Ferrari

BoxBall: Load A Complete Baseball History Dataset Into Postgres — Looking for a bit dataset with which to play more with Postgres and, particularly, cstore_fdw? This pre-built Docker image could be just the ticket.

David Roher

🗓 Upcoming Postgres Events

  • PostgreSQL Ibiza (Jun 19-21 on Ibiza) — Spain's famous party island promises you both "Postgres on the beach" while still having talks and training in a neat looking venue.
  • Postgres Vision 2019 (June 24-26 in Boston, MA) — Sir Tim Berners-Lee, the inventor of the Web, is delivering the keynote.
  • PostgresLondon 2019 (July 2-3 in London, UK)
  • PostgresConf Beijing 2019 (July 3-6 in Beijing, China)
  • PGConf.Brasil 2019 (August 1-3 in São Paulo) — A three day PG conference with talks, tutorials, courses, Couch Clinic, and lightning talks.
  • PGDay Austria 2019 (September 6 in Wiener Neustadt, Austria)

🔬 A Periodic Table of psql Commands (Again!)

Last week we included this table of psql commands (courtesy of Marcelo Diaz of Cybertec) but failed to link to a higher resolution version for your own printing or safe-keeping!

Thanks to everyone who emailed in pointing out this problem.. this has now been resolved, so here is the chart again and it now links to a higher resolution copy here :-)