Multiple Databases, Slow Queries, Sorting Performance | Scaling Postgres 27
In this episode of Scaling Postgres, we review articles covering scaling with multiple databases, detecting slow queries, and sorting performance.
Subscribe at https://www.scalingpostgres.com to get notified of new episodes.
Links for this episode:
https://tech.instacart.com/scaling-at-instacart-distributing-data-across-multiple-postgres-databases-with-rails-13b1e4eba202
https://www.cybertec-postgresql.com/en/3-ways-to-detect-slow-queries-in-postgresql/
https://www.cybertec-postgresql.com/en/postgresql-improving-sort-performance/
https://karolgalanciak.com/blog/2018/08/19/indexes-on-rails-how-to-make-the-most-of-your-postgres-database/
https://rob.conery.io/2018/08/13/transactional-data-operations-in-postgresql-using-common-table-expressions/
https://haughtcodeworks.com/blog/software-development/recursive-sql-queries-using-ctes/
https://www.citusdata.com/blog/2018/05/15/fun-with-sql-recursive-ctes/
https://www.percona.com/blog/2018/08/21/foreign-data-wrappers-postgresql-postgres_fdw/
https://www.percona.com/blog/2018/08/24/postgresql-accessing-mysql-as-a-data-source-using-mysql_fdw/
https://www.youtube.com/watch?v=RJ5kRaBCV78
Create your
podcast in
minutes
It is Free