Profiling PL/pgSQL Code on Amazon RDS or Aurora with plprofiler — plprofiler is a Postgres extension that creates performance profiles of functions and stored procedures. While it can be used on any Postgres system, it’s available on Amazon’s Postgres platforms now and here's a look at using it (whether using AWS or not).

Madiwale, Akula and Shaik (AWS)

5mins of Postgres - A New Weekly Video Series About Postgres — Every Thursday, pganalyze CEO Lukas Fittl publishes a short video to comment on the most noteworthy Postgres content from the previous 7 days. Subscribe to our YouTube channel and enjoy tomorrow's episode of 5mins of Postgres.

pganalyze sponsor

Tuning Postgres' max_wal_size Setting — The max_wal_size configuration parameter sets the write ahead log (WAL) size that triggers a new checkpoint in the log and the setting can have a profound effect on performance, says the author.

Dave Page (EDB)

How Sharding a Database Can Make It Faster — The author, an AWS Data Hero and undoubted expert in the topic of database sharding, looks at how sharding remains a common way to improve performance through distributing load. Not Postgres specific, though Notion recently had a post about how they sharded Postgres.

Trista Juan Pan

Using pgTAP to Automate Database Testing — Keep your pianoPostgres in tune with pgTAP, a suite of database functions to help with writing TAP-emitting unit tests in psql scripts or xUnit-style test functions.

Josh Tolley

Query Parameter Data Types and Performance — Laurenz recently helped a customer solve a performance problem leading from a poor choice of query parameter type (when using JDBC) which, in turn, led to poor query performance.

Laurenz Albe

6 Challenges Wix Faced While Building a Super CI Pipeline

Buildkite sponsor

Database Design: Using Documents — It’s not the era of ‘NoSQL’ anymore but the idea of using a document model in database systems continues to offer some appeal. Luckily Postgres and JSON can give us access to a document-based approach while still remaining efficient.

Emre Hasegeli

PLV8 3.1: The JavaScript V8 Engine, But for Postgres — Postgres’s extensibility means you don’t have to solely use PL/pgSQL for adding more functionality to your database – you could use, say, Perl or JavaScript, instead. PLV8 brings the latter into play. Documentation.

plv8 team

DBeaver 22: A Universal Database Tool — Written in Java, this is a long standing, open-source, cross-platform database tool for building and running queries, looking at tables, execution plans, etc.

DBeaver Team

Directus: Wrap an SQL Database with a Real-Time GraphQL + REST API — A Node.js-powered open source system that can act as a frontend to Postgres, SQLite, MySQL, Oracle, and other SQL databases, and provide a modern dashboard, client, and both REST and GraphQL APIs.

Directus