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
- Single User Mode and -P flag
- 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
- Using R in Postgres for Logistic Regression Modeling
- Improved OpenStreetMap data structure in PostGIS
- Amit Langote
YouTube Video
