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

RapidLoop

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

CITUS DATA, NOW PART OF MICROSOFT sponsor

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