When Postgres Development Stopped! | Scaling Postgres 319

To get the show notes as well as get notified of new episodes, visit:
https://www.scalingpostgres.com/episodes/319-when-postgres-development-stoppped/

In this episode of Scaling Postgres, we discuss a time when Postgres development stopped, two new extensions pg_lakehouse & pg_compare and the upcoming event Posette.

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
00:11 - How engaging was PGConf.dev really?
01:17 - pg_lakehouse: A DuckDB Alternative in Postgres
03:07 - PostgreSQL Performance Starter Kit
03:22 - Introducing pgCompare: The Ultimate Multi-Database Data Comparison Tool
05:25 - Sponsoring the community
06:02 - Ultimate Guide to POSETTE: An Event for Postgres, 2024 edition
06:24 - Postgres Planner QuirksL: OIN Equivalence Classes and IN/ANY filters
07:41 - PG Phriday: Taking Postgres for GRANTed
08:29 - FOREIGN KEYS IN POSTGRESQL: CIRCULAR DEPENDENCIES
09:24 - Controlling Resource Consumption on a PostgreSQL Server Using Linux cgroup2
10:23 - PostgreSQL Hybrid Search Using pgvector and Cohere
11:04 - RAG app with Postgres and pgvector
11:21 - PGVector as Embedding Store in PrivateGPT
11:40 - Outro

#postgres #postgresql

Видео When Postgres Development Stopped! | Scaling Postgres 319 канала Scaling Postgres

PostgreSQL Scaling PostgreSQL PostgreSQL Performance

Комментарии отсутствуют

Информация о видео

10 июня 2024 г. 2:00:00

00:12:06

Scaling Postgres

Теги

Правообладателям

Жалоба на материал Недопустимый материал Нарушение авторских прав

Комментарии

Другие видео канала

When Postgres Development Stopped! | Scaling Postgres 319

Scaling Postgres Episode 15 | Leveraging Postgres | Tuning Autovacuum | Slow Queries

15% - 250% Faster Query Throughput | Scaling Postgres 287

Scaling Postgres Episode 219 Out-Of-Cycle Release, Should You Upgrade, Survey, Automatic Indexing

PGlite: Embeddable Postgres & postgres.new | Scaling Postgres 329

Scaling Postgres Episode 223 DB Decomposition, Fast Text Search, Understanding pg_stat_activity

Scaling Postgres Episode 147 DBMS of the Year | Better Data Migrations | Idle Connection Impact

Scaling Postgres Episode 28 | Watch | Fast Text Search | Column Defaults | Import CSVs

11TB WAL, pgec Writes, Patroni 3 & Citus, PostgREST | Scaling Postgres 256

Scaling Postgres Episode 54 | Index-Only Scans | Lock Table | Hot Standby Feedback | Large Backups

Scaling Postgres Episode 88 Partitioning | Logical Replication Upgrade | Columnar Compress | HAProxy

Scaling Postgres Episode 72 | Collation Issues | Fast Loading | Recovery | SCRAM Authentication

Scaling Postgres Episode 83 Postgres 12 | Window Frames | Index Types | Synchronous Replication

Scaling Postgres Episode 224 Column Performance, BRIN Win, Unique and Null, Parallel Distinct

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

Scaling Postgres Episode 243 IN vs ANY, Ghost Conditions, Percentage Calculations, Variadic Unnest

pg_stat_statements, Transaction ID Wraparound, Consultant Knowledge, CitusCon | Scaling Postgres 265

Postgres 17 Beta 1 Released | Scaling Postgres 318

Postgres Releases, PostgreSQL Survey, Partitioning vs. Sharding, Bulk Loading | Scaling Postgres 277

Scaling Postgres Episode 95 max_locks_per_transaction | Logical Replication | Backup & Recovery

Scaling Postgres Episode 198 Monitoring Progress, More SQL, Replication Slot Fail Over, Contributors