Postgres 17 Beta 1 Released | Scaling Postgres 318

Рет қаралды 1,001

Күн бұрын

To get the show notes as well as get notified of new episodes, visit:
www.scalingpostgres.com/episo...
In this episode of Scaling Postgres, we discuss all the new features in Postgres 17 Beta 1, some features that did not make it, database collations & sorting and causes of slow commits.
Want to learn more about Postgres performance?
Join my FREE mini-course called the PostgreSQL Performance Starter Kit here: www.scalingpostgres.com/cours...
Timestamps:
00:00 - Intro
00:19 - PostgreSQL 17 Beta 1 Released!
03:43 - What's (not) in Postgres 17 beta1, and how to test it
05:15 - Default Sort Order in Db2, SQL Server, Oracle & Postgres 17
06:44 - PostgreSQL Performance Starter Kit
07:02 - Why do I have a Sloq Commit in PostgreSQL
09:31 - How We Fused DuckDB into Postgres with Crunchy Bridge for Analytics
10:55 - Top Five PostgreSQL Surprise from Rails Devs
12:59 - Full text Search
14:37 - Carbon Footprint and Query Optimization
15:10 - Custom PostgreSQL extensions with Rust
16:18 - Converting DMS to PostGIS Point Geometry
16:59 - PostgreSQL Data Cleaning vs. Python Data Cleaning
17:26 - Outro
#postgres #postgresql

Пікірлер: 3

@professortrog7742 Ай бұрын

The carbon footprint of bad queries is something i include in all my presentations since 3 years. According to my calculations ORMs alone cause a loss of around 900 MW on PostgreSQL databases . That is roughly the peak output of Heyden Powerplant in Germany, one of the biggest coal-burning installations in Europe.

@jaimeduncan6167 Ай бұрын

The lack of progress toward having a modern engine, and the fact that was not stoped because of a bug but because they want to keep the platform as is, is appalling, to say the least.

@DylanYoung Ай бұрын

Modern engine for what? And what do you mean by modern?