Squeeze Your System, 1 Million Connections, Indexing LIKE, pgvector HNSW | Scaling Postgres 278 скачать в хорошем качестве

Squeeze Your System, 1 Million Connections, Indexing LIKE, pgvector HNSW | Scaling Postgres 278

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 how to squeeze the most out of your database, achieving 1 million connections to Postgres, how to use indexes with LIKE and pgvector HNSW index performance. Want to learn more about Postgres performance? Join my FREE mini-course called the PostgreSQL Performance Starter Kit here: https://www.scalingpostgres.com/cours... Timestamps: 00:00 - Intro 01:10 - Squeeze the hell out of the system you have 03:23 - Comments on Squeeze the hell out of the system you have 04:22 - Supavisor: Scaling Postgres to 1 Million Connections 07:11 - Indexing "Like" In PostgreSQL and Oracle 09:05 - An Early Look at HNSW Performance with PGVector 11:39 - Sharding 12:45 - Fun with PostgreSQL Puzzles: Recursive Functions with Animations 12:59 - How we Reduced Downtime by 100x: Supplementing pgBackrest EBS Snapshots 14:14 - How an AWS Aurora feature cut our DB costs by 90% 14:54 - Episode 6 highlights of Path To Citus Con podcast w/ Chelsea Dole & Floor Drees 15:14 - Balancing Act: Achieving High Availability with HAProxy for PostgreSQL 15:32 - Outro #postgres #postgresql