Andrew Atkinson

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 Rails Podcast

We recently faced a challenge working with a large table where query performance had worsened. This table is high growth tracking activity as applicants move through a hiring process.

PostgreSQL Open Source

This month’s PGSQL Phriday topic prompts writers to discuss how their team manages PostgreSQL database schema changes.

PostgreSQL Rails Open Source

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

Productivity Tips Open Source

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.

PostgreSQL Open Source Conferences Events

I’m late to the party, but wanted to sneak in a PGSQL Phriday entry for this community blog post series.

PostgreSQL Rails Open Source

I joined Julie and Andrew as a guest on the Ruby For All Podcast!💎

PostgreSQL Rails Podcast

PostgreSQL 15 shipped in late 2022 (See PostgreSQL 15 Release Notes), including interesting new features like SQL MERGE. I wanted to give them a try.

PostgreSQL DevOps

Hello. I recently tweeted asking the following question.

PostgreSQL Rails