Andrew Atkinson

This week I’m participating in a virtual social learning experiment run by Phil Eaton / https://twitter.com/eatonphil, called “#wehack PostgreSQL Internals”.

Open Source PostgreSQL

Just got back from the whirlwind 🌪️ of PGConf NYC 2023 in Midtown Manhattan.🗽

Conferences Open Source PostgreSQL Events

A few months ago I joined the SaaS Developer Community to learn more about challenges SaaS developers face.

Podcasts Ruby on Rails Open Source PostgreSQL

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.

Podcasts PostgreSQL Ruby on Rails Open Source

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...

PostgreSQL Ruby on Rails Open Source Books

This month’s PGSQL Phriday #011 prompts bloggers to write about Sharding and Partitioning in PostgreSQL.

PostgreSQL Ruby on Rails Open Source

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 Ruby on Rails Ruby Podcasts

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...

PostgreSQL Open Source

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 Ruby on Rails Podcasts

Hello! We recently faced challenges in working with a large table, performing operations, and query performance had worsened a lot.

PostgreSQL Open Source