~postgresweekly | Issue 592 - How about 1 trillion rows in Postgres? (5)

1 Trillion Rows in Citus? — “Postgres scales,” but just how far does that go? Hans-Jürgen decided to find out, running a little (or is it big?) experiment to see if a 1 trillion row table is even achievable.

❌ Ways to Cancel Queries in Postgres — If you’ve got a query or two hogging Postgres’s resources, terminating them is an option, and there are several ways to go about it.

▶ Don’t Let Postgres Maintenance Slip Through the Cracks — Secure your spot to learn the proactive maintenance practices that uncover hidden database performance risks, like slow queries, checkpoint behavior, & connection issues, before they escalate.

Postgres Gets a Self-Join Elimination Optimization — Several years ago, someone suggested a join optimization where redundant inner self-joins (often added by ORMs) can be removed under certain conditions. This so-called Self-Join Elimination (SJE) optimization has now been committed to Postgres and is explained in this GitHub commit.

Introducing pgNow: A Point-in-Time Diagnostic Tool — A free (but not open – it’s in preview behind an email wall) cross-platform desktop tool created by Redgate to highlight and analyze live data about queries, indexes, configuration settings, and other important elements of a Postgres cluster’s operation. Even if you don’t grab it, Ryan gives a thorough overview of what it offers here.