SQL Query Optimization: Understanding Key Principle [https://hinty.io/devforth/sql-query-optimization-understanding-key-principle/] - 2021-06-07 23:56:23 - public:aguynamedryan performance, sql - 2 | id:684304 -
SQL Optimizations in PostgreSQL: IN vs EXISTS vs ANY/ALL vs JOIN - Percona Database Performance Blog [https://www.percona.com/blog/2020/04/16/sql-optimizations-in-postgresql-in-vs-exists-vs-any-all-vs-join/] - 2021-01-20 22:18:34 - public:aguynamedryan performance, pg - 2 | id:488444 -
Squash N+1 queries early with n_plus_one_control test matchers for Ruby and Rails — Martian Chronicles, Evil Martians’ team blog [https://evilmartians.com/chronicles/squash-n-plus-one-queries-early-with-n-plus-one-control-test-matchers-for-ruby-and-rails] - 2020-10-29 19:23:51 - public:aguynamedryan library, performance, rails - 3 | id:436616 -
pg_squeeze: Optimizing PostgreSQL storage - Cybertec [https://www.cybertec-postgresql.com/en/pg_squeeze-optimizing-postgresql-storage/] - 2020-10-14 16:16:36 - public:aguynamedryan performance, pg - 2 | id:416631 -
MatheusRich/benchable: Write benchmarks without the hassle. [https://github.com/Matheusrich/benchable] - 2020-08-20 18:24:54 - public:aguynamedryan library, try, ruby, performance - 4 | id:366365 -
Monitoring demystified: A guide for logging, tracing, metrics | Hacker News [https://news.ycombinator.com/item?id=24006697&utm_term=comment] - 2020-08-07 16:40:01 - public:aguynamedryan performance - 1 | id:363173 -
Scaling relational SQL databases – Software development and beyond [https://stribny.name/blog/2020/07/scaling-relational-sql-databases] - 2020-08-07 15:45:35 - public:aguynamedryan performance, rdbms, scale - 3 | id:363167 -
From 25 Minutes to 7 Minutes: Improving the Performance of a Rails CI Pipeline [https://kellysutton.com/2020/05/18/speeding-up-a-rails-continuous-integration-pipeline.html] - 2020-05-30 02:40:34 - public:aguynamedryan ci, dive, performance, ruby - 4 | id:321633 -
Understanding Cost Models [http://justinjaffray.com/understanding-cost-models/] - 2020-05-15 18:16:57 - public:aguynamedryan db, performance, rdbms - 3 | id:310305 -
How to Fix Slow Code in Ruby – Shopify Engineering [https://engineering.shopify.com/blogs/engineering/how-fix-slow-code-ruby] - 2020-05-15 16:04:08 - public:aguynamedryan ruby, dive, performance - 3 | id:310304 -
The Practical Effects of the GVL on Scaling in Ruby [https://www.speedshop.co/2020/05/11/the-ruby-gvl-and-scaling.html] - 2020-05-14 17:56:23 - public:aguynamedryan dive, performance, ruby - 3 | id:310261 -
PostgreSQL Gets a Parallel Processing Boost [https://www.datanami.com/2020/04/27/postgresql-gets-a-parallel-processing-boost/] - 2020-05-03 16:35:16 - public:aguynamedryan performance, pg - 2 | id:309959 -
PostgreSQL troubleshooting extension | pg_show_plans - CYBERTEC [https://www.cybertec-postgresql.com/en/detailed-look-on-the-new-postgresql-troubleshooting-extension-pg_show_plans/] - 2020-04-15 15:58:19 - public:aguynamedryan performance, pg - 2 | id:292959 -
A Beginners Guide to Basic Indexing | James Bannister [https://bannister.me/blog/a-beginners-guide-to-basic-indexing/] - 2020-04-15 15:57:44 - public:aguynamedryan performance, pg - 2 | id:292958 -
pg_show_plans: Watching execution plans in PostgreSQL LIVE - Cybertec [https://www.cybertec-postgresql.com/en/pg_show_plans-watching-execution-plans-in-postgresql-live/] - 2020-04-01 20:28:34 - public:aguynamedryan pg, performance, explain - 3 | id:290994 -
Useful Queries For PostgreSQL Index Maintenance - Percona Database Performance Blog [https://www.percona.com/blog/2020/03/31/useful-queries-for-postgresql-index-maintenance/] - 2020-04-01 20:27:53 - public:aguynamedryan performance, pg - 2 | id:290993 -
mgartner/pg_flame: A flamegraph generator for Postgres EXPLAIN ANALYZE output. [https://github.com/mgartner/pg_flame] - 2020-02-21 03:38:50 - public:aguynamedryan performance, pg - 2 | id:283166 -
Optimization Techniques by Benchmark Winners — Juanito Fatas [https://juanitofatas.com/optimization_techniques_by_benchmark_winners] - 2020-02-01 14:31:59 - public:aguynamedryan dive, performance, ruby - 3 | id:279066 -
How to Write Fast Code in Ruby on Rails [https://engineering.shopify.com/blogs/engineering/write-fast-code-ruby-rails] - 2019-10-18 17:21:06 - public:aguynamedryan rails, performance, ruby - 3 | id:279012 -