100 TB and Beyond! | Scaling Postgres 320

In this episode of Scaling Postgres, we discuss three organizations scaling their databases to 100 TB and beyond, collation speed, configuring memory and new AI extensions.

Content Discussed

• To 100TB, and beyond!
• How much speed you’re leaving at the table if you use default locale?
• How to Get the Most out of Postgres Memory Settings
• PGSQL Phriday #017
• Making PostgreSQL a Better AI Database
• Pgai: Giving PostgreSQL Developers AI Engineering Superpowers
• Pgvector vs. Pinecone: Vector Database Performance and Cost Comparison
• How We Made PostgreSQL as Fast as Pinecone for Vector Data
• PostgreSQL and Pgvector: Now Faster Than Pinecone, 75% Cheaper, and 100% Open Source
• CloudNativePG Recipe 8: Participating in PostgreSQL 17 Testing Program in Kubernetes
• CloudNativePG on minicube on openSUSE Leap Micro 6
• CloudnativePG – Bootstrapping an empty cluster
• CloudNativePG – Configuring the PostgreSQL instance
• CloudNativePG – PostgreSQL extensions
• CloudNativePG – The kubectl plugin
• CloudNativePG – Scaling up and down
• 2024.pgconf.dev and Growing the Community
• Benchmark Amazon RDS for PostgreSQL Single-AZ DB instance, Multi-AZ DB instance, and Multi-AZ DB Cluster deployments
• Waiting for Postgres 17: Better Query Plans for Materialized CTE Scans
• Deep Dive into PostgREST - Time Off Manager (Part 3)
• PGTT Extension for Global Temporary Tables in PostgreSQL
• Performance impact of using ORDER BY with LIMIT in PostgreSQL
• Exploring the Power of Partitioning in PostgreSQL
• Exploring PostgreSQL 17: A Developer’s Guide to New Features – Part 1 – PL/pgSQL
• Exploring PostgreSQL 17: A Developer’s Guide to New Features – Part 2 – Null’s Constraint and Performance.
• SQL/PGQ and graph theory
• IndieRails Podcast — Andrew Atkinson - The Postgres Specialist
• Community feelings at P2D2 2024
• Announcing Crunchy Postgres for Kubernetes 5.6: New Features for Seamless Postgres Management

YouTube Video

Podcast Audio