Faster Writes With ZFS? | Scaling Postgres 342 скачать в хорошем качестве

Faster Writes With ZFS? | Scaling Postgres 342

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 the read and write performance of Postgres on ZFS, handling URL text identifiers in the database, denormalization and a new pgvector release. Want to learn more about Postgres performance? Join my FREE training called Postgres Performance Demystified here: https://www.scalingpostgres.com/cours... Scaling Postgres 341 Timestamps: 00:00 - Intro 00:36 - PostgreSQL: Maybe we should give ZFS a chance (1) – baseline 01:43 - PostgreSQL: Maybe we should give ZFS a chance (2) – testing 03:58 - Text identifiers in PostgreSQL database design 07:15 - Denormalization 08:47 - pgvector 0.8.0 Released! 09:51 - Announcing: pgvector 0.8.0 released and available on Nile 10:05 - Accessing Large Language Models from PostgreSQL 11:39 - 8 Steps in Writing Analytical SQL Queries 12:06 - Deploying the Zalando Kubernetes operator 12:28 - [YouTube] PostgreSQL Conference Europe 2024 Playlist 12:39 - Hacking Postgres: Heikki Linnakangas 12:53 - Outro #postgres #postgresql