Issue 366 - Fill factors, SQL style, and figuring out prices in Postgres (13)

GoodJob: A New Postgres-Based, Multithreaded, Background Job System for Ruby on Rails — Ben calls GoodJob a “second-generation” backend because it focuses on compatibility with ActiveJob. It’s suited for use cases queuing fewer than 1 million jobs/day.

What is 'Fill Factor' and How Does It Affect Performance? — The ‘fill factor’ defines just how tightly packed table storage is. For example, when a row is updated, the ‘new’ row might end up in a different page of storage due to size limitations, whereas a less tightly packed table would allow the update to happen almost in situ.

A SQL Style Guide — We linked to this a couple of years ago but Bruce Momjian has reminded us of this handy SQL style guide to ensure legible and maintainable queries.

[Case Study] Successful Migration to PostreSQL by Global Gaming Company — Learn how 2ndQuadrant helped International Gaming Technology (IGT) successfully Migrate to PostgreSQL from an expensive and proprietary DBMS to deliver high quality gaming experiences worldwide, as well as how they've experienced zero outages since the switch.

Unicode Normalization in Postgres 13 — If you know nothing about what ‘fully composed’ or ‘fully decomposed’ means when it comes to Unicode or what Postgres does when considering the equality of Unicode strings, this is a short and sweet introduction to some ideas you might not need to know in detail but should probably know about.

Avoiding Passwords in Log Files — “Because Postgres uses SQL queries to manage user accounts, including password assignment, it is possible for passwords to appear in the server logs..”

A Safer Price Type in Postgres — Is it worth modelling prices by creating a domain/type rather than just sticking to cents in a number column? Vados experiments.

Postgres 13's EXPLAIN Now Includes WAL Information — You’ll be able to see how many WAL records are created and similar info.

Installing TimescaleDB on macOS with Postgres.app — TimescaleDB is a popular time series data Postgres extension and Postgres.app is an equally popular way to run Postgres on the Mac. This tutorial brings the two together.

Using Custom Types with Citus and Postgres, From Popular Hack to Transparent Feature — How custom types work with Citus and how user-defined PostgreSQL types are automatically propagated to all the nodes in a Citus cluster.

▶  Postgres Performance Tuning and Optimization — An hour-long talk that focuses on tuning configuration settings (both in Postgres and on Linux generally) and what things they each affect.

What It Was Like Speaking Online at EuroPython 2020 — A speaker shares a little of the experience of giving a talk at an online conference.

Identify Slow-Running PostgreSQL Queries Quickly in Datadog — Improve PostgreSQL performance by visualizing and identifying errors fast using granular, out-of-the-box dashboards in Datadog.