Scaling Postgres Episode 147 DBMS of the Year | Better Data Migrations | Idle Connection Impact | Security Implementation Guide
Get New Episodes Weekly!
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.
Content Discussed
PostgreSQL is the DBMS of the Year 2020
Stop worrying about PostgreSQL locks in your Rails migrations
Resources consumed by idle PostgreSQL connections
Performance impact of idle PostgreSQL connections
How to limit rows to at most N per category – fix
Announcing the Crunchy Data PostgreSQL Security Technical Implementation Guide
PostgreSQL Database Security: What You Need To Know
Single User Mode and -P flag
Using R in Postgres for Logistic Regression Modeling
Improved OpenStreetMap data structure in PostGIS
Amit Langote
