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...
Code With Jason 190 — PostgreSQL and Sin City Ruby 🎙️
I joined Jason Swett recently on his podcast and had a great time. The podcast topic was PostgreSQL Table Partitioning and how developers can use it. We also discussed the 2024 edition of Sin City Ruby, a conference Jason organizes...
PostgreSQL Table Partitioning — Growing the Practice — Part 1 of 2
Hello! We recently faced challenges in working with a large table, performing operations, and query performance had worsened a lot.
PGSQL Phriday #009 — Database Change Management
This month’s PGSQL Phriday topic prompts writers to discuss how their team manages PostgreSQL database schema changes.
Better Markdown Writing With Vale
Vale is a command-line writing assistant I’ve been using to improve my writing quality. Vale runs as a command line program and accepts a path to a text file. I use it with Markdown formatted text files to check for...
PGDay Chicago 2023 Conference
I had the chance to present on Table Partitioning this year at PGDay Chicago 2023, and had a great time. I wanted to recap my experience.