
Helping Rails developers learn Postgres with Andrew Atkinson
11/15/24 • 94 min
Have you ever achieved something remarkable because someone planted an idea in your mind? In this episode of Talking Postgres, host Claire Giordano talks with Andrew Atkinson—a Rails developer and Postgres user whose journey to becoming a published author began with a simple seed of inspiration. Andrew’s story started with an internal presentation on how to tackle tricky scalability challenges in Rails, grew into a Postgres conference talk at PGConf NYC—and ultimately evolved into his book, High Performance PostgreSQL for Rails. Also in this episode: what does cheese have to do with Postgres? Is writing a good way to think? What’s the connection between Postgres and swimming to Antarctica? And which chapter of his book does Andrew love the most?
Links mentioned in this episode:
- Book: High Performance PostgreSQL for Rails by Andrew Atkinson
- E-book Discount: Use discount code TalkingPostgres to get 35% off discount of Andrew’s book
- Blog post: Readers get their copies of High Performance PostgreSQL for Rails by Andrew Atkinson
- Book: Swimming to Antarctica: Tales of a Long Distance Swimmer by Lynne Cox
- Talk Abstract: PGConf NYC 2021 talk by Andrew Atkinson
- Slides: PGConf NYC 2021 talk on How We Made PG Fitter, Happier, More Productive by Andrew Atkinson
- Video: POSETTE 2024 talk about SaaS on Rails on PostgreSQL by Andrew Atkinson
- Ruby User Groups: List of upcoming Ruby user groups
- Blog post: Writing is Thinking, an annotated twitter thread by Steve Sinofsky
- Talking Postgres podcast Ep19: Becoming a Postgres committer with Melanie Plageman
- Talking Postgres podcast Ep20: How I got started as a developer (& in Postgres) with David Rowley
- CFP: Prague PostgreSQL Developer Day 2025 (P2D2) CFP open until Nov 23, 2024
- CFP: FOSDEM PGDay 2025 CFP open until Nov 29, 2024
- CFP: Nordic PGDay 2025 CFP open until Dec 31, 2024
- CFP: pgDay Paris 2025 CFP open until Dec 31, 2024
- CFP: PGConf.dev 2025 CFP open until Jan 01, 2025
- CFP: POSETTE: An Event for Postgres 2025 CFP open until Feb 09, 2025
- Calendar invite: LIVE recording of Ep22 of Talking Postgres podcast
Have you ever achieved something remarkable because someone planted an idea in your mind? In this episode of Talking Postgres, host Claire Giordano talks with Andrew Atkinson—a Rails developer and Postgres user whose journey to becoming a published author began with a simple seed of inspiration. Andrew’s story started with an internal presentation on how to tackle tricky scalability challenges in Rails, grew into a Postgres conference talk at PGConf NYC—and ultimately evolved into his book, High Performance PostgreSQL for Rails. Also in this episode: what does cheese have to do with Postgres? Is writing a good way to think? What’s the connection between Postgres and swimming to Antarctica? And which chapter of his book does Andrew love the most?
Links mentioned in this episode:
- Book: High Performance PostgreSQL for Rails by Andrew Atkinson
- E-book Discount: Use discount code TalkingPostgres to get 35% off discount of Andrew’s book
- Blog post: Readers get their copies of High Performance PostgreSQL for Rails by Andrew Atkinson
- Book: Swimming to Antarctica: Tales of a Long Distance Swimmer by Lynne Cox
- Talk Abstract: PGConf NYC 2021 talk by Andrew Atkinson
- Slides: PGConf NYC 2021 talk on How We Made PG Fitter, Happier, More Productive by Andrew Atkinson
- Video: POSETTE 2024 talk about SaaS on Rails on PostgreSQL by Andrew Atkinson
- Ruby User Groups: List of upcoming Ruby user groups
- Blog post: Writing is Thinking, an annotated twitter thread by Steve Sinofsky
- Talking Postgres podcast Ep19: Becoming a Postgres committer with Melanie Plageman
- Talking Postgres podcast Ep20: How I got started as a developer (& in Postgres) with David Rowley
- CFP: Prague PostgreSQL Developer Day 2025 (P2D2) CFP open until Nov 23, 2024
- CFP: FOSDEM PGDay 2025 CFP open until Nov 29, 2024
- CFP: Nordic PGDay 2025 CFP open until Dec 31, 2024
- CFP: pgDay Paris 2025 CFP open until Dec 31, 2024
- CFP: PGConf.dev 2025 CFP open until Jan 01, 2025
- CFP: POSETTE: An Event for Postgres 2025 CFP open until Feb 09, 2025
- Calendar invite: LIVE recording of Ep22 of Talking Postgres podcast
Previous Episode

How I got started as a developer (& in Postgres) with Tom Lane
It was not Tom Lane’s plan to become a computer person. Tom’s plan was to be a pinball machine designer. And yet for the last 26 years Tom has been one of the most prolific engineering contributors to Postgres. In this episode of Talking Postgres with Claire Giordano, PostgreSQL luminary Tom Lane walks us through how he got his start as a developer and in Postgres—including his time working on desktop calculators at HP. And how he has code running on Mars (and most of us don’t.) During Tom’s PhD studies at Carnegie Mellon, nobody told him databases were so interesting! It wasn’t until Tom needed a database to store stock trading information that he first got to work with Postgres. And that’s when Tom’s 26-year-long (and counting) Postgres story began.
Links mentioned in this episode:
- Wikipedia: Tom Lane (computer scientist)
- Wikipedia: HP 9800 series
- CMU CS Department Coke Machine history
- Wikipedia: Honeywell 316
- Wikipedia: Teletype Model 33
- Wikipedia: Hydra (operating system)
- Wikipedia: William Wulf
- Wikipedia: Jon Bentley (computer scientist)
- Wikipedia: Mary Shaw (computer scientist)
- Wikipedia: Usenet
- GitHub: postgres commit by tglsfdc
- Article: The Mars 2020 Engineering Cameras and Microphone on the Perseverance Rover: A Next-Generation Imaging System for Mars Exploration by J.N. Maki et al.
- Blog: Open Source on Mars: Community powers NASA’s Ingenuity Helicopter by Klint Finley
- PostgreSQL Mailing List message: pg_upgrade --check fails to warn about abstime
- PostgreSQL: Core Team
- postgresql.git: commitdiff
- Blog: Proton to Fastmail by Tristan Partin
- Talking Postgres Ep18: How I got started as a dev (& in Postgres) with David Rowley
- PGConf EU 2024: Conference Schedule
- PGConf NYC 2024: Conference Schedule
- Talking Postgres Ep19: Becoming a Postgres committer with Melanie Plageman
- PostgreSQL: Commitfests
- Wikipedia: Cutting room floor
- PostgreSQL Mailing List message: Straight-from-the-horses-mouth dept
- PostgreSQL Mailing List message: [PATCH] Extend ALTER OPERATOR to support adding commutator, negator, hashes, and merges
Next Episode

Leading engineering for Postgres on Azure with Affan Dar
What’s it like to lead Postgres engineering at a cloud giant like Microsoft Azure? In this episode of Talking Postgres, host Claire Giordano chats with Affan Dar, VP of Engineering for Postgres at Microsoft. Affan’s team is behind the Azure Database for PostgreSQL managed service and also contributes extensively to the upstream Postgres open-source project. Affan walks us through his career journey—from his first job as an embedded systems engineer, to navigating the shift between engineering and management, to leading one of the largest Postgres engineering teams in the world. He shares the strategy behind Microsoft’s investments into Postgres, explores how massive cloud fleets are influencing the future of Postgres, and shares what keeps him up at night.
Links mentioned in this episode:
- Docs: Azure Database for PostgreSQL – Flexible Server
- GitHub repo for Durable Task Framework, the first open source project Affan worked on
- GitHub repo for pgvector open source extension to Postgres
- Docs: Elastic cluster feature in Azure Database for PostgreSQL – Flexible Server, based on Citus
- GitHub repo for Citus open source
- Blog post: Postgres horizontal scaling with elastic clusters on Azure Database for PostgreSQL, by Adam Wølk
- GitHub repo for DiskANN open source
- Docs: How to enable and use the DiskANN index for Azure Database for PostgreSQL – Flexible Server
- Blog post: Think of language models like ChatGPT as a “calculator for words” by Simon Willison
- Blog post: What’s new with Postgres at Microsoft (updated 2x/year typically)
- Video of Talk at Microsoft Ignite: Improving accuracy of GenAI apps with Azure Database for PostgreSQL by Maxim Lukiyanov (Microsoft), Jay Yang (UBS), & Orhun Oezbek (UBS)
- CFP: POSETTE: An Event for Postgres 2025 CFP open until Feb 9 2025
- Calendar invite: LIVE recording of Ep23 of Talking Postgres podcast to happen on Wed Jan 15, 2025 with guest Daniel Gustafsson
If you like this episode you’ll love
Episode Comments
Generate a badge
Get a badge for your website that links back to this episode
<a href="https://goodpods.com/podcasts/talking-postgres-with-claire-giordano-268946/helping-rails-developers-learn-postgres-with-andrew-atkinson-78433774"> <img src="https://storage.googleapis.com/goodpods-images-bucket/badges/generic-badge-1.svg" alt="listen to helping rails developers learn postgres with andrew atkinson on goodpods" style="width: 225px" /> </a>
Copy