Faster Paging? | Scaling Postgres 325

To get the show notes as well as get notified of new episodes, visit:
https://www.scalingpostgres.com/episodes/325-faster-paging/

In this episode of Scaling Postgres, we discuss more ways to keep the superior performance of keyset pagination, how to implement UUIDv7 in SQL functions, how expensive extended statistics are and the benefits of range columns.

Want to learn more about Postgres performance?
Join my FREE training called Postgres Performance Demystified here: https://www.scalingpostgres.com/courses/postgres-performance-demystified/

Timestamps:
00:00 - Intro
00:43 - Keyset pagination with descending order
05:45 - Implementing UUIDs v7 in pure SQL
08:59 - How expensive is it to maintain extended statistics?
11:42 - Simplifying Time-Based Queries with Range Columns
13:35 - Basics of Tuning Checkpoints
16:33 - Autovacuum Tuning Basics
17:51 - CloudNativePG – Benchmarking
18:07 - system logs aggregation with postgres
18:57 - Can Postgres replace Redis as a cache?
19:41 - Postgres startup ecosystem
19:41 - Outro

#postgres #postgresql

Видео Faster Paging? | Scaling Postgres 325 канала Scaling Postgres