🇺🇦 #​447 — March 23, 2022

Web Version

Postgres Weekly

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

In brief:

  • PostgreSQL Day Poland 2022, due to take place next month, has been postponed given the situation till later in the year due to Russia's invasion of Ukraine.

  • A look at support for security invoker views coming to Postgres 15: "A security invoker view checks permissions for accessing its underlying base relations using the privileges of the user of the view, rather than the privileges of the view owner."

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

Installing Pgpool-II on Debian or Ubuntu
Bo Peng

🔧 Code and Tools:

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

PGX 0.4.0: Build Postgres Extensions with Rust
ZomboDB