Scaling Postgres Episode 114 Data Directory | Vacuum Features | Binary Performance | Network Latency

Описание: To get the show notes as well as get notified of new episodes, visit:
https://www.scalingpostgres.com/episo...

In this episode of Scaling Postgres, we discuss the Postgres data directory, new vacuum features, binary storage performance and the impact of network latency.

Want to learn more about Postgres performance?
Join my FREE mini-course called the PostgreSQL Performance Starter Kit here: https://www.scalingpostgres.com/cours...

Timestamps:
00:00 - Intro
00:28 - PostgreSQL 12.3, 11.8, 10.13, 9.6.18, and 9.5.22 Released!
01:02 - yum users: some -devel RPMs require a new repository
01:36 - Don't Manually Modify The PostgreSQL Data Directory!
04:51 - Improved (auto)vacuum in PostgreSQL 13
07:24 - Binary data performance in PostgreSQL
09:52 - PostgreSQL: Network latency does make a BIG difference
11:14 - Postgres Distinct On
12:01 - Overcoming Impostor Syndrome: Working with PostgreSQL's SSL Modes
14:47 - Benefits of External Key Management System Over the Internal and How they Could Help Securing PostgreSQL
15:42 - Keep your libraries updated and nobody gets hurt
17:00 - Multicolumn Partitioning
17:41 - PgBadger: X-Ray Vision for Your Queries
18:11 - Key Parameters and Configuration for Streaming Replication in Postgres 12
18:37 - Fuzzy Searching with PostgreSQL
18:08 - Advanced SQL and database books and resources
19:35 - Build PostgreSQL and Extension on Windows
19:48 - Fabrízio de Royes Mello
20:04 - Outro

#postgres #postgresql