Andy Atkinson
andyatkinson.com · Personal blog · on HN since 2019
Andy Atkinson writes about PostgreSQL and Ruby on Rails, covering partitioning, UUID keys, query performance, and caching.
What HN saysHN links it for practical Postgres and Rails advice. The author himself comments, mentioning a book on these topics that uses Rails examples.
20HN people shared it
2linked it in comments
34stories submitted
641story points
4 months agolast shared
2019people per year2026
Most-shared posts
- 1Django and Postgres for the Busy Rails Developer3 people · 183 points · first shared 2024 · 120 comments on HN
- 2Merging and Splitting Partitions with Minimal Locking in PostgreSQL 173 people · 5 points · first shared 2024 · 1 comments on HN
- 3Avoid UUID Version 4 Primary Keys in Postgres2 people · 382 points · first shared 2025 · 449 comments on HN
- 4Big Problems From Big IN lists with Ruby on Rails and PostgreSQL2 people · 10 points · first shared 2025 · discussion on HN
- 5Top Five PostgreSQL Surprises from Rails Developers2 people · 10 points · first shared 2024 · 2 comments on HN
- 6Tip: Put your Rails app on a SQL query diet2 people · 7 points · first shared 2025 · discussion on HN
- 7Short alphanumeric pseudo random identifiers in Postgres2 people · 6 points · first shared 2025 · discussion on HN
- 8Trying Out Solid Queue and Mission Control with PostgreSQL2 people · 4 points · first shared 2024 · discussion on HN
- 9Solid Cache for Rails and PostgreSQL2 people · 4 points · first shared 2024 · 1 comments on HN
- 10Scaling Rails for a Peak Load of 41M Requests/Hour2 people · 2 points · first shared 2026 · discussion on HN
- 11Homepage2 people · first shared 2022
- 12Christmas Outage to #1 App Store Ranking: An Aura Frames Postgres Scaling Retro1 people · 5 points · first shared 2026 · discussion on HN
- 13Shrinking Big PostgreSQL Tables with the Copy-Swap-Drop Technique1 people · 5 points · first shared 2024 · discussion on HN
- 14PostgreSQL Indexes: Prune and Tune1 people · 3 points · first shared 2021 · discussion on HN
- 15Core Database Design1 people · 3 points · first shared 2025 · discussion on HN
What HN people wrote when they linked it
andatki · 2024-08-17
Great list of Postgres features called out that highlight the extensive feature set.
Most of these are covered in my book, for anyone that’s interested in learning them. The book uses a Ruby on Rails app with Postgres instances for examples and exercises. Hope the plug is ok here as some folks may be looking for learning resources for Postgres. https://andyatkinson.com/pgrailsbook
jhas78asd · 2023-07-04
PostgreSQL and Ruby on Rails.
https://andyatkinson.com/