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