Scaling Postgres Episode 115 PGCon Online | Performance Tips | Count Tracking | Essential Monitoring

To get the show notes as well as get notified of new episodes, visit:

In this episode of Scaling Postgres, we discuss PGCon going online, application performance tips, ways to track counts and essential areas to monitor.

Want to learn more about Postgres performance?

Timestamps:
00:00 - Intro
00:28 - PostgreSQL 13 Beta 1 Released!
00:53 - PGCon - PostgreSQL Conference for Users and Developers
01:27 - Postgres tips for optimizing Django & Python performance, from my PyCon workshop
02:34 - How to count hits on a website in PostgreSQL
05:10 - SQL Window Functions Cheat Sheet
05:45 - Essential PostgreSQL Monitoring - Part 1
07:36 - Failover of Logical Replication Slots in PostgreSQL
09:27 - Is it Time to Upgrade your PostgreSQL Database?
10:31 - Phoney table columns in PostgreSQL
11:54 - Dimitri Fontaine
12:07 - How to use Logistic Regression Machine Learning model with 2UDA – PostgreSQL and Orange (Part 5)
12:26 - Outro

#postgres #postgresql

[MrAtomUniverse]

It seems like Postgres 13 has got slower Read as compared to Postgres 12, hopefully that is temporary