PGSQL Phriday #014 — PostgreSQL Events
This post is my contribution to the PGSQL Phriday #014 blog post series. Here’s the invitation:
Latest Articles
Teach Kelvin Your Thing (TKYT) — High Performance PostgreSQL for Rails 🖥️
Recently I met Kelvin Omereshone, based in Nigeria, for a session on his show Teach Kelvin Your Thing (TKYT). Here’s the description of the show:
PostgreSQL IO Visibility: #wehack PostgreSQL Internals and pg_stat_io
This week I’m participating in a virtual social learning experiment run by Phil Eaton / https://twitter.com/eatonphil, called “#wehack PostgreSQL Internals”.
PGConf NYC 2023 Recap 🐘
Just got back from the whirlwind 🌪️ of PGConf NYC 2023 in Midtown Manhattan.🗽
SaaS for Developers with Gwen Shapira — Postgres, Performance and Rails with Andrew Atkinson 🎙️
A few months ago I joined the SaaS Developer Community to learn more about challenges SaaS developers face.
Podcast: Code and the Coding Coders who Code it! Episode 27 Andrew Atkinson 🎙️
I had the chance to join Drew Bragg on his podcast “Code and the Coding Coders who Code It” and we had a great conversation.
Presenting 'Partitioning Billions of Rows' at SFPUG August 2023
On August 8, 2023 I had the chance to present to the San Francisco Bay Area PostgreSQL User Group (SFPUG) on our case study for a recent online table partitioning migration. The main tools we used were PostgreSQL 13 and...
PGSQL Phriday #011 — Sharding and Partitioning
This month’s PGSQL Phriday #011 prompts bloggers to write about Sharding and Partitioning in PostgreSQL.
Slow & Steady — Database Constraints with Andrew Atkinson 🎙️
Benedikt Deicke (co-founder of UserList) recently hosted me on the Slow & Steady podcast (co-hosted by Benedicte Raae). Our main topic was Database Constraints, why they’re useful and how to use them.
PostgreSQL Table Partitioning Primary Keys — The Reckoning — Part 2 of 2
In Part 2 of this 2 part PostgreSQL 🐘 Table Partitioning series, we’ll focus on how we modified the Primary Key online for a large partitioned table. This is a disruptive operation so we had to use some tricks to...