Postgres 17 Released! | Scaling Postgres 335
Join Over 1,000 Engineers & Get New Episodes Weekly!
In this episode of Scaling Postgres, we discuss the release of Postgres 17, b-tree performance gains, logical replication enhancements and different levels of performance tuning.
Content Discussed
- PostgreSQL 17 Released!
- Real World Performance Gains With Postgres 17 B-tree Bulk Scans
- Online Upgrading Logical and Physical Replication Nodes
- PostgreSQL Performance Tuning: Optimize Your Database Server
- Planning time
- Building an image search engine on Postgres
- Building an AI Image Gallery: Advanced RAG With Pgvector and Claude Sonnet 3.5
- A few secure, random bytes without `pgcrypto`
- CNPG Playground: A New Learning Environment for Postgres in Kubernetes
- Exploring PostgreSQL 17: A Developer’s Guide to New Features – Part 7: pg_maintain Predefined Role for Maintenance.
- Kubernetes Requests and Limits for Postgres
- pgBackRest backups from the standby server
- pgBackRest dedicated backup host
- Trying out Solid Queue and Mission Control with PostgreSQL
- Solid Cache for Rails and PostgreSQL
- PostgreSQL: Partitioned tables and optimizer statistics
- PostgreSQL: pg_dump and extension ownership
- Hierarchical data types
- Transitioning from Oracle to PostgreSQL: Understanding the Concept of Schema
- Using pg_upgrade to Upgrading Your PostgreSQL Cluster on Windows
- Nicolas Payart
- PostgreSQL 17: part 5 or CommitFest 2024-03
- Playing with BOLT and Postgres
- Retrieval-Augmented Generation With Claude Sonnet 3.5 and Pgvector
- Tips for PostgreSQL Query Optimization: EXPLAIN ANALYZE
- PostGIS 3.5.0
- Prague PostgreSQL Meetup on September 30th
- PGDay Hyderabad 2024 Reflections
- Postgres 17 is Now Available on Neon
- Vehicle Routing with PostGIS and Overture Data
- Scaling PostgreSQL to Petabyte Scale
- Boosting 400x Query Performance for Tiered Data on S3 in PostgreSQL
- 4,300 GitHub Stars and Counting: CloudNativePG Now the World’s #1 PostgreSQL Operator for Kubernetes
- Running Postgres in Kubernetes: The Shift from ‘Why’ to ‘How’
- PostgreSQL vs MySQL: Partitioning, Replication, Query Optimization, and More
- Edge Functions are now 2x smaller and boot 3x faster