filmov
tv
Scaling Postgres Episode 48 | Microsoft Acquires Citus Data | Split WAL | Maintenance Work Memory
Показать описание
To get the show notes as well as get notified of new episodes, visit:
In this episode of Scaling Postgres, we review articles covering Microsoft acquiring Citus Data, split WAL files, maintenance_work_mem and logical replication.
Want to learn more about Postgres performance?
Timestamps:
00:00 - Intro
00:23 - Microsoft acquires Citus Data, re-affirming its commitment to Open Source and accelerating Azure PostgreSQL performance and scale
01:19 - Microsoft Acquires Citus Data: Creating the World’s Best Postgres Experience Together
01:35 - Lessons from building VeniceDB: YouTube
02:19 - The Curious Case of Split WAL Files
04:04 - How Much maintenance_work_mem Do I Need?
06:18 - How We Solved a Storage Problem in PostgreSQL Without Adding a Single Byte of Storage
08:21 - PostgreSQL Logical Replication Gotchas
11:13 - pg_permission: Inspecting your PostgreSQL security system
12:26 - Scheduling Backups En Masse with the Postgres Operator
13:06 - What's New in Crunchy PostgreSQL Operator 3.5
13:29 - 2ndQuadrant PostgreSQL YouTube
14:18 - Outro
#postgres #postgresql
In this episode of Scaling Postgres, we review articles covering Microsoft acquiring Citus Data, split WAL files, maintenance_work_mem and logical replication.
Want to learn more about Postgres performance?
Timestamps:
00:00 - Intro
00:23 - Microsoft acquires Citus Data, re-affirming its commitment to Open Source and accelerating Azure PostgreSQL performance and scale
01:19 - Microsoft Acquires Citus Data: Creating the World’s Best Postgres Experience Together
01:35 - Lessons from building VeniceDB: YouTube
02:19 - The Curious Case of Split WAL Files
04:04 - How Much maintenance_work_mem Do I Need?
06:18 - How We Solved a Storage Problem in PostgreSQL Without Adding a Single Byte of Storage
08:21 - PostgreSQL Logical Replication Gotchas
11:13 - pg_permission: Inspecting your PostgreSQL security system
12:26 - Scheduling Backups En Masse with the Postgres Operator
13:06 - What's New in Crunchy PostgreSQL Operator 3.5
13:29 - 2ndQuadrant PostgreSQL YouTube
14:18 - Outro
#postgres #postgresql
0:14:43
Scaling Postgres Episode 48 | Microsoft Acquires Citus Data | Split WAL | Maintenance Work Memory
0:14:21
Scaling Postgres Episode 49 | Over One Billion | No Downtime | SQL Life | Throughput
0:16:57
Scaling Postgres Episode 138 Connection Scaling | TimescaleDB | Time-series Gaps | Red & Gold Si...
0:11:17
Scaling Postgres Episode 47 | pgBouncer | Postgres 11 Gems | DocumentDB | JSON
0:17:46
Scaling Postgres Episode 39 | Bloat vs zHeap | Composite Indexes | Unsafe Operations
0:11:55
Scaling Postgres Episode 148 Hash Indexes | Int Float Numeric | Postgres 14 Features | Data Science
0:17:04
Scaling Postgres Episode 218 PG14 Index Bug, View Permissions, Logical Replication Conflicts
0:15:14
Scaling Postgres Episode 69 | Performance Training | JSON Path | Hypothetical Index | Interpolation
0:15:19
Scaling Postgres Episode 239 Shared Buffers, WAL Compression, Merge Command, Postgres Contributions
0:11:42
Scaling Postgres Episode 46 | Stuck Transaction IDs | pgBouncer Auth | UUIDs | Monitoring
0:12:14
Scaling Postgres Episode 11 | Serializable | JSON & JSONB | Fast Data Loading | PG11 Features
0:17:33
Scaling Postgres Episode 18 | Impact of Virtualization | Compressing Data | Parallelism
0:19:50
Postgres Sort Instability? | Scaling Postgres 322
0:12:58
Scaling Postgres Episode 70 | Default Security | Max Connections | Progress Reporting | Migration
0:12:15
Scaling Postgres Episode 77 | Timeseries Queries | Arrays | Ranges | C Triggers
0:15:55
Scaling Postgres Episode 174 Lateral Joins | Generating JSON | dbcritic | Fetch First Rows
0:15:01
Scaling Postgres Episode 125 Scaling | Slot Safety | SCRAM Channel Binding | Effective Cache Size
0:13:39
When Select Writes! | Scaling Postgres 333
0:17:48
Scaling Postgres Episode 222 PG 15 Beta 2, Concerning Locks, Vacuum Tuning, Transaction Anomalies
0:15:40
Scaling Postgres Episode 62 | Index Include Clause | Exporting CSV | JSON | Zedstore
0:00:55
'Postgres doesn't scale well' and other BS we say as software devs
0:15:17
Scaling Postgres Episode 201 JSONB Performance, Bidirectional Replication, Recent Records, PG14 JSON
0:10:48
Scaling Postgres Episode 162 Custom Data Types | Row Level Trigger | Dynamic plpgsql Column | citext
0:13:48
Scaling Postgres Episode 80 Just Upgrade | Vacuum Updates | Connection Strings | Postgres Showcase
Комментарии