100 TB and Beyond! | Scaling Postgres 320

Рет қаралды 923

Күн бұрын

To get the show notes as well as get notified of new episodes, visit:
www.scalingpostgres.com/episo...
In this episode of Scaling Postgres, we discuss three organizations scaling their databases to 100 TB and beyond, collation speed, configuring memory and new AI extensions
Want to learn more about Postgres performance?
Join my FREE training called Postgres Performance Demystified here: www.scalingpostgres.com/cours...
Timestamps:
00:00 - Intro
00:23 - To 100TB, and beyond!
02:43 - Postgres Performance Demystified
03:18 - How much speed you're leaving at the table if you use default locale?
05:30 - How to Get the Most out of Postgres Memory Settings
09:35 - PGSQL Phriday #017
09:53 - Making PostresQL a Better AI Database
12:38 - Pgai: Giving PostgreSQL Developers AI Engineering Superpowers
12:48 - Pgvectore vs. Pinecone: Vecto Database Performance and Cost Comparison
12:53 - How We Made PostgreSQL as Fast as Pinecone for Vector Data
13:05 - PostgreSQL and Pgvector: Now Faster Than Pinecone, 75% Cheaper, and 100% Open Source
13:15 - CloudNativePG Recipe 8: Participating in PostgreSQK 17 Testing Program in Kubernetes
13:36 - CloudNativePG - on minicube on openSUSE Leap Micro6
13:55 - CloudNativePG - Bootstraping an empty cluster
14:00 - CloudNativePG - Configuring the PostgreSQL instance
14:03 - CloudNativePG - PostgreSQL extensions
14:06 - CloudNativePG - The kubectl plugin
14:08 - CloudNativePG - Scaling up and down
14:16 - 2024.pgconf.dev and Growing the Community
14:42 - Benchmark Amazon RDS for PostgreSQL Single-AZ DB instance, Multi-AZ instance, and Multi-AZ DB Cluster deployments
17:07 - Outro
#postgres #postgresql

Пікірлер: 4

@rosendo3219 Ай бұрын

so cute to see timescale utilizing same font and format as Apple does on their wwdc presentations :)

@NikolaySamokhvalov Күн бұрын

as usual, thanks for mention! Adyen that you haven''t heard yet - in the U.S., you can accidentally see when paying for something. E.g. I see it in legoland california :)

@jaimeduncan6167 Ай бұрын

2024, the first 64bit phone was the iPhone 5s, circa Sep 2013, the first 64 bit PC was Apple and AMD introduced the first 64 bit mainstream PC, and depending on who you ask either the DEC Alpha or the R4000 was the first mainstream 64 bit workstation microprocessors in 1991-1992. Even so 32 years after the change and 28 years after Postgresql introduction we still have transaction wraparound problems because the xid is still 32 bits. Postgresql continue to grow but they are not aware that they are Perl before the collapse.

@jaimeduncan6167 Ай бұрын

Thanks for all the good work you do.