HNSW Indexes, Vacuuming Bloat, Watch Me Now, Connections | Scaling Postgres 281

To get the show notes as well as get notified of new episodes, visit:
https://www.scalingpostgres.com/episodes/281-hnsw-indexes-vacuuming-bloat-watch-me-now-connections/

In this episode of Scaling Postgres, we discuss the benefits and disadvantages of HNSW indexes for working with vector data, configuring vacuum to reduce bloat and optimize performance, the new options available for \watch and all about connections.

Want to learn more about Postgres performance?
Join my FREE mini-course called the PostgreSQL Performance Starter Kit here: https://www.scalingpostgres.com/courses/postgresql-performance-starter-kit/

Timestamps:
00:00 - Intro
01:07 - pgvector v0.5.0: Faster semantic search with HNSW indexes
04:20 - HNSW Indexes with Postgres and pgvector
06:59 - Optimizing Postgres's Autovacuum for High-Churn Tables
11:35 - PostgreSQL 17: Allow "\watch" to stop based on the number of rows returned
13:23 - Waiting for PostgreSQL 17 - Allow "\watch" to stop based on the number of rows returned
13:35 - Waiting for PostgreSQL 17 - Generate new Log for "trust" connections under log_connections
13:58 - Waiting for PostgreSQL 17 - Add to_bin() and to_oct().
14:14 - Connecting over TCP IP or using Linux Sockets
14:44 - Now it's PostgreSQL's turn to have a bogus CVE
15:02 - CVE-2020-21469 is not a security vulnerability
15:39 - Courtesy Notification: CVE-2020-21469 PostgreSQL 12.2 Security Vulnerability
15:49 - PostgreSQL 16 Improves Infinity: PgSQLPhriday #01
16:10 - Exploring Postgres Performance: A Deep Dive into pg_stat_statements
16:47 - Outro

#postgres #postgresql

Видео HNSW Indexes, Vacuuming Bloat, Watch Me Now, Connections | Scaling Postgres 281 канала Scaling Postgres