10 Costly Database Performance Mistakes
(And How to Fix Them)
All presentations on GitHub: andyatkinson/presentations
Book Giveaway
- Sign up for my newsletter at https://pgrailsbook.com or at the bottom of this page
- Confirm your email address
- Once confirmed, reply with “enter me into the book giveaway contest”
That’s it! I’ll keep track of your entry, and do a drawing at RailsConf. If you win, I’ll email you. Good luck!
See other readers who got their copies 👉
Check our meeting readers at Rails World and Madison Ruby 👉
Past RailsConf Conference Experiences
- RailsConf 2024 Conference — The Long Goodbye
- 2024 Workshop YouTube recording: RailsConf 2024 - Build High Performance Active Record Apps by Andrew Atkinson
- 2024 Workshop GitHub repo: RailsConf 2024 Workshop
- 2022 RailsConf 2022 Conference
- RailsConf 2017
- RailsConf Conference 2010 Baltimore
Extra Content
RailsConf 2025: The Past, the Present, and the Future of Rails
- Past: 1970s!1
- Present: PostgreSQL, MySQL, SQLite, 2024 Rails Survey,2 2700 responses
- Future: PostgreSQL, MySQL, SQLite, in top 10 of 424 per db-engines3
rails_best_practices gem
rails_best_practices gem
Presentation Links
- 1. atlassian.com/git/tutorials/comparing-workflows/gitflow-workflow
- 2. atlassian.com/continuous-delivery/continuous-integration/trunk-based-development
- 3. railsdeveloper.com/survey/2024/#deployment-devops
- 4. dora.dev/guides/dora-metrics-four-keys
- 5. octopus.com/devops/metrics/space-framework
- 6. a.co/d/0Sk81B9
- 7. dora.dev/quickcheck
- 8. github.com/simplecov-ruby/simplecov
- 9. github.com/ankane/strong_migrations
- 10. github.com/sbdchd/squawk
- 11. github.com/andyatkinson/anchor_migrations
- 12. github.com/andyatkinson/rideshare/pull/230
- 13. en.wikipedia.org/wiki/Object–relational_impedance_mismatch
- 14. postgres.fm/episodes/over-indexing
- 15. andyatkinson.com/generating-short-alphanumeric-public-id-postgres
- 16. andyatkinson.com/presentations/blob/main/pass2024/README.md
- 17. andyatkinson.com/constraint-driven-optimized-responsive-efficient-core-db-design
- 18. github.com/djezzzl/database_consistency
- 19. andyatkinson.com/source-code-line-numbers-ruby-on-rails-marginalia-query-logs
- 20. postgresql.org/docs/current/auto-explain.html
- 21. postgres.ai/blog/20220106-explain-analyze-needs-buffers-to-improve-the-postgres-query-optimization-process
- 22. mysql.com/products/enterprise/em.html
- 23. sqlite.org/sqlanalyze.html
- 24. andyatkinson.com/blog/2024/05/28/top-5-postgresql-surprises-from-rails-developers
- 25. andyatkinson.com/big-problems-big-in-clauses-postgresql-ruby-on-rails
- 26. andyatkinson.com/tip-track-sql-queries-quantity-ruby-rails-postgresql
- 27. ddnexus.github.io/pagy/docs/api/keyset/
- 28. island94.org/2024/03/rails-active-record-will-it-bind
- 29. blog.appsignal.com/2018/06/19/activerecords-counter-cache.html
- 30. depesz.com/2024/12/01/sql-best-practices-dont-compare-count-with-0
- 31. bigbinary.com/blog/rails-6-adds-implicit_order_column
- 32. andycroll.com/ruby/safely-remove-a-column-field-from-active-record
- 33. github.com/fatkodima/online_migrations
- 34. github.com/andyatkinson/pg_scripts/pull/18
- 35. github.com/andyatkinson/pg_scripts/blob/main/find_missing_indexes.sql
- 36. github.com/pganalyze/lint
- 37. github.com/HypoPG/hypopg
- 38. github.com/andyatkinson/pg_scripts/pull/19
- 39. github.com/andyatkinson/rideshare/pull/232
- 40. github.com/scenic-views/scenic
- 41. andyatkinson.com/blog/2023/07/27/partitioning-growing-practice
- 42. github.com/public-activity/public_activity
- 43. github.com/paper-trail-gem/paper_trail
- 44. github.com/collectiveidea/audited
- 45. github.com/ankane/ahoy
- 46. andyatkinson.com/copy-swap-drop-postgres-table-shrink
- 47. github.com/palkan/logidze
- 48. andyatkinson.com/blog/2023/08/17/postgresql-sfpug-table-partitioning-presentation
- 49. github.com/danmayer/coverband
- 50. why-upgrade.depesz.com
- 51. andyatkinson.com/blog/2021/07/30/postgresql-index-maintenance
- 52. github.com/NikolayS/postgres_dba
- 53. cybertec-postgresql.com/en/products/pg_squeeze
- 54. maintainable.fm/episodes/andrew-atkinson-maintainable-databases
- 55. wa.aws.amazon.com/wellarchitected/2020-07-02T19-33-23/wat.concept.mechanical-sympathy.en.html
- 56. github.com/cerebris/jsonapi-resources
- 57. github.com/rmosolgo/graphql-ruby
- 58. github.com/activeadmin/activeadmin
- 59. boringrails.com/tips/active-record-to-sql
- 60. github.com/andyatkinson/rideshare/pull/233
- 61. cybertec-postgresql.com/en/hot-updates-in-postgresql-for-better-performance
- 62. andyatkinson.com/blog/2022/10/07/pgsqlphriday-2-truths-lie
- 63. jordanhollinger.com/2023/11/11/rails-strict-loading
