Postgres 16 Beta 1, Rust Functions, Partition Memory Problems, Tags & Arrays | Scaling Postgres 267

Описание: 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 release of PostgreSQL 16 Beta 1, creating Rust functions with PL/Rust, memory problems related to partitioning and prepared statements, and modeling tags with arrays.

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:29 - PostgreSQL 16 Beta 1 Released!
01:32 - Postgres 16 Release Notes
01:39 - PostgreSQL 16: part 5 or CommitFest 2023-03
01:55 - More Memory, More Problems
03:27 - Postgres: on performance of prepared statements with partitioning
04:00 - A Postmortem on High Memory Usage with Prepared Statements
04:37 - Build high-performance functions in Rust on Amazon RDS for PostgreSQL
06:06 - Tags and Postgres Arrays, a Purrrfect Combination
08:45 - PGSQL Phriday #009 Invitation: Making Changes
09:18 - 5 Ways to Get Table Creation Information in Postgres
11:07 - Huge Pages and PostgreSQL
12:38 - Tuning huge pages in Postgres
12:49 - How to Secure PostgreSQL: Security Hardening Best Practices & Tips
13:54 - ChatGPT plugins now support Postgres & Supabase
14:22 - Using v4 of the Postgres H3 extension
14:54 - Corruption
15:10 - Florin Irion
15:20 - Monetizing Your Content Part 2 With Seb Wilgosz | Rubber Duck Dev Show 86
15:39 - Outro

#postgres #postgresql