filmov
tv
Scaling Postgres Episode 23 | UUIDs | Write Spikes | Distinct | SQL Standard
Показать описание
To get the show notes as well as get notified of new episodes, visit:
In this episode of Scaling Postgres, we review articles covering UUIDs, the source of write spikes, uses of distinct and SQL standards support.
Want to learn more about Postgres performance?
Timestamps:
00:00 - Intro
00:23 - UUIDs and Compressibility
02:30 - Troubleshooting Daily Write Spikes on Cermati’s PostgreSQL RDS
05:00 - High performance distributed DML in Citus
08:10 - The many faces of DISTINCT in PostgreSQL
10:22 - How PostgreSQL’s SQL dialect stays ahead of its competitors
11:34 - Batch Updates and Concurrency
12:38 - Troubleshooting PostgreSQL Streaming Replication Synchronization
14:15 - Outro
#postgres #postgresq
In this episode of Scaling Postgres, we review articles covering UUIDs, the source of write spikes, uses of distinct and SQL standards support.
Want to learn more about Postgres performance?
Timestamps:
00:00 - Intro
00:23 - UUIDs and Compressibility
02:30 - Troubleshooting Daily Write Spikes on Cermati’s PostgreSQL RDS
05:00 - High performance distributed DML in Citus
08:10 - The many faces of DISTINCT in PostgreSQL
10:22 - How PostgreSQL’s SQL dialect stays ahead of its competitors
11:34 - Batch Updates and Concurrency
12:38 - Troubleshooting PostgreSQL Streaming Replication Synchronization
14:15 - Outro
#postgres #postgresq
0:14:41
Scaling Postgres Episode 23 | UUIDs | Write Spikes | Distinct | SQL Standard
0:19:00
23 Or 1.1 Times Faster Performance? | Scaling Postgres 284
0:12:32
Scaling Postgres Episode 24 | Full Text Search | jsonb_agg | Upgrades | CIS
0:13:29
Scaling Postgres Episode 123 JSONB Types | Earth Distance | Dates Times & Intervals | Authentica...
0:19:42
Scaling Postgres Episode 21 | Using JSON | Procedures | Concurrency | Kubernetes
0:17:36
Scaling Postgres Episode 221 psql Shortcuts, Debugging Deadlocks, Find & Stop Queries, Using SCR...
0:14:38
Scaling Postgres Episode 127 Recursive Queries | Lateral Joins | Pagination | JSONB Arrays
0:14:46
Scaling Postgres Episode 146 Active-Active & Federated | Memory Speed | Table Rewrites | Shibbol...
0:23:50
Lets Build Twitter From the Ground Up: Episode 259 || Java, Spring Boot, PostgreSQL and React
0:15:59
Squeeze Your System, 1 Million Connections, Indexing LIKE, pgvector HNSW | Scaling Postgres 278
0:14:09
Scaling Postgres Episode 65 | Multi Column | Multi DB | Dos & Don'ts | RUM Indexes
0:15:09
Scaling Postgres Episode 170 Redis vs Postgres | Hard Quadrant | Optimizing Join | Materialized View
0:18:54
Scaling Postgres Episode 237 PG 15 Released, File Systems, Connection Pooling, Secure Connections
0:13:28
Scaling Postgres Episode 29 | Parallel Indexing | SQL vs. ORM | Logical Replication Upgrades
0:14:36
Scaling Postgres Episode 197 Explain Analyze Buffers, Healthier PG, 2021 Review, High Availability
0:16:34
Scaling Postgres Episode 217 Schema Change Mistakes, Canceling Statements, pg_rman, Pedantry Removal
0:12:40
Scaling Postgres Episode 172 Per-Operation Explain | PG14 Contributions | Foreign Parallel Execution
0:14:21
Scaling Postgres Episode 49 | Over One Billion | No Downtime | SQL Life | Throughput
0:16:21
Scaling Postgres Episode 234 Rust Extensions, Timescale vs. Postgres, Shard Uninterrupted, Data Flow
0:12:08
Scaling Postgres Episode 63 | Slow Queries | pg_auto_failover | Roles | Hyperscale
0:11:39
Scaling Postgres Episode 242 Reduce Replication Lag, Explain Parameterized Query, Multiple PgBouncer
0:18:32
Scaling Postgres Episode 195 Aurora vs. Postgres, Surprising Transactions, Write-Only & Read-Onl...
0:11:33
Postgres Goes Parquet | Scaling Postgres 339
0:15:40
Scaling Postgres Episode 62 | Index Include Clause | Exporting CSV | JSON | Zedstore
Комментарии