

High Performance Postgres with Andrew Atkinson
Jul 2, 2024
Author Andrew Atkinson shares insights on optimizing Postgres for Rails, including schema tightness, operation handling, and performance testing. The podcast covers Andrew's journey of writing a book, indexing pitfalls, database best practices, and advanced Postgres features. Discussions range from balancing book writing with work, investing in private companies, to potential NBA trade decisions.
Chapters
Transcript
Episode notes
1 2 3 4 5 6 7 8 9
Intro
00:00 • 2min
Exploring High-Performance Postgres for Web Applications with an Author and Consultant
02:01 • 12min
Optimizing Indexes and Performance in Postgres Databases
13:35 • 19min
Database Best Practices: Foreign Keys, Cascade Deletes, Check Constraints, Functions, and Triggers
32:07 • 9min
Optimizing Postgres Performance and Utilizing Advanced Features
41:04 • 18min
Journey of Writing a Database Book and Balancing Work
59:31 • 8min
Investing in Private Companies and Career Influences
01:07:35 • 3min
Debating future code writing trends and discussing potential NBA trade decisions
01:10:12 • 2min
Performance Reflections and Book Promotion
01:12:08 • 2min