Scaling Postgres

In this episode of Scaling Postgres, we discuss PostgreSQL as the DBMS of the year, running better data migrations, the impact of idle connections and a security implementation guild. Subscribe at https://www.scalingpostgres.com to get notified of new episodes. Links for this episode: https://db-engines.com/en/blog_post/85 https://medium.com/doctolib/stop-worrying-about-postgresql-locks-in-your-rails-migrations-3426027e9cc9 https://aws.amazon.com/blogs/database/resources-consumed-by-idle-postgresql-connections/ https://aws.amazon.com/blogs/database/performance-impact-of-idle-postgresql-connections/ https://www.depesz.com/2021/01/08/how-to-limit-rows-to-at-most-n-per-category-fix/ https://info.crunchydata.com/blog/announcing-the-crunchy-data-postgresql-stig https://www.percona.com/blog/2021/01/04/postgresql-database-security-what-you-need-to-know/ https://fluca1978.github.io/2021/01/03/PostgreSQLSingleUserModeP.html https://info.crunchydata.com/blog/using-r-in-postgres-for-logistic-regr