20,000 Times Faster Order By Limit | Scaling Postgres 366 скачать в хорошем качестве

20,000 Times Faster Order By Limit | Scaling Postgres 366

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 a top ten dangerous Postgres issues list, importing and exporting statistics, more Postgres 18 beta features and a 20,000 times faster query by fixing an order by limit issue. Want to learn more about Postgres performance? Join my FREE training called Postgres Performance Demystified here: https://www.scalingpostgres.com/cours... Timestamps: 03:33 - Top ten dangerous issues 05:18 - PostgreSQL 18 Beta Preview – Export or Amend Statistics with Ease 06:12 - Good time to test io_method (for Postgres 18) 07:42 - Postgres 18 Beta Is Out: 7 Features You Should Know About 08:34 - Understanding PostgreSQL Write-Ahead Logging (WAL) 09:03 - Understanding logical replication in Postgres 10:06 - Migrating to Postgres 10:36 - Neon and Databricks 10:52 - How I got started with FerretDB (& why we chose Postgres) with Peter Farkas 11:35 - Consulting Corner 14:27 - Outro #postgres #postgresql