Faster Paging? | Scaling Postgres 325

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.

Content Discussed

• Keyset pagination with descending order
• Implementing UUIDs v7 in pure SQL
• How expensive is it to maintain extended statistics?
• Simplifying Time-Based Queries with Range Columns
• Basics of Tuning Checkpoints
• Autovacuum Tuning Basics
• CloudNativePG – Benchmarking
• system logs aggregation with postgres
• Postgres startup ecosystem
• Can Postgres replace Redis as a cache?
• SaaS on Rails on PostgreSQL — POSETTE 2024
• Exploring PostgreSQL 17: A Developer’s Guide to New Features – Part 3: The COPY Command Gets More User-Friendly
• Postgres Roles: What to Know Before You Begin
• Ozgun Erdogan
• RFC: PGXN Meta Spec v2
• Use pg_easy_replicate for setting up Logical Replication and Switchover in PostgreSQL
• PGDay UK2024
• Introducing multi-version schema migrations
• Announcing Supabase on JSR
• Supabase Security Suite
• Development environments for AWS RDS using Neon Postgres
• How to Install TimescaleDB on AWS
• Designing a simple and scalable RBAC system

YouTube Video

Podcast Audio