75 subscribers
Переходьте в офлайн за допомогою програми Player FM !
Подкасти, які варто послухати
РЕКЛАМА


Slow Queries, pg_auto_failover, Roles, Hyperscale | Scaling Postgres 63
Manage episode 442671291 series 2140130
In this episode of Scaling Postgres, we review articles covering how to identify slow queries, the pg_auto_failover utility, working with roles and Hyperscale.
To get the show notes as well as get notified of new episodes, visit:
https://www.scalingpostgres.com/episodes/63-slow-queries-pg_auto_failover-roles-hyperscale/
544 епізодів
Manage episode 442671291 series 2140130
In this episode of Scaling Postgres, we review articles covering how to identify slow queries, the pg_auto_failover utility, working with roles and Hyperscale.
To get the show notes as well as get notified of new episodes, visit:
https://www.scalingpostgres.com/episodes/63-slow-queries-pg_auto_failover-roles-hyperscale/
544 епізодів
Усі епізоди
×


1 Postgres 16 Released, The Postgres Meme, File vs base64 Strings, Intelligent Sharding | Scaling Postgres 282 14:00


1 Postgres 16 RC1, Bi-Directional Replication, All About Parameters, Foreign Keys & Polymorphism | Scaling Postgres 280 21:09

1 TPS Benchmark, Partition-wise Join & Aggregate, Partitioning Billions, Posgres 16 Features | Scaling Postgres 279 15:59

1 Squeeze Your System, One Million Connections, Indexing LIKE, pgvector HNSW | Scaling Postgres 278 15:58

1 Postgres Releases, PostgreSQL Survey, Partitioning vs. Sharding, Bulk Loading | Scaling Postgres 277 19:04

1 BRIN & Correlation, Poor Partitioning, 10 Beginner Tips, Table & Index Usage | Scaling Postgres 276 15:57

1 No More Vacuum, Zero-Downtime Cut-Over, Network Impact, Not In Optimization | Scaling Postgres 275 13:17

1 Subquery Performance, Avoid Update Locking, Column Changes, Outage Workshop | Scaling Postgres 274 14:40


1 Postgres 16 Beta 2, The Rise of Vectors, FDW Performance, Unused Indexes | Scaling Postgres 272 14:39





1 PostgreSQL 16 Beta 1, Rust Functions, Partitioning Memory Problems, Tags & Arrays | Scaling Postgres 267 16:03

1 Postgres Releases, Postgres Distributed, Privilege Template, Real-Time Dashboards | Scaling Postgres 266 16:53

1 pg_stat_statements, Transaction ID Wraparound, Consultant Knowledge, CitusCon | Scaling Postgres 265 16:47


1 LZ4 & ZSTD Compression, Avoiding Problems, Triggers Simplify, Indexes Can Hurt | Scaling Postgres 263 19:14

1 pg_failover_slots, Standby Logical Decoding, Trusted Language Extensions, Postgres Package Manager | Scaling Postgres 262 14:43

1 Easy Foreign Data Wrappers, JSONB Cheatsheet, Updating Cost Limit, Parallel Aggregate | Scaling Postgres 261 16:24


1 Logical Replication, Database Antipatterns, max_wal_size Setting, Delete vs. Truncate | Scaling Postgres 258 8:41


1 Integer Overflow, User-Friendly Permissions, Dump & Logical Replication, Worker Config | Scaling Postgres 255 17:43

1 PG Edge Cache, Postgres & OpenAI, citext to Collations, Compression Options | Scaling Postgres 254 13:14


1 Postgres Releases, Performance Secrets, Don't Do This, Filter vs. Case | Scaling Postgres 252 14:56


1 Performance Issue, Survive Without Superuser, Reserved Connections, Partition Management | Scaling Postgres 250 14:03


1 Pagination Solutions, Return Modifications, Insert Deletions, How To JSON | Scaling Postgres 248 17:20

1 Generate Test Data, Faster Archiving, Date Statistics, Useless Indexes | Scaling Postgres 247 14:25


1 ENUMs vs Check Constraints, Faceting With Roaring Bitmaps, Better Scaling, In DB Business Logic | Scaling Postgres 245 11:40

1 Index Merge vs Composite, Transparent Column Encryption, Trusted Language Extensions | Scaling Postgres 244 14:59

1 IN vs ANY, Ghost Conditions, Percentage Calculations, Variadic Unnest | Scaling Postgres 243 10:25

1 Reduce Replication Lag, Explain Parameterized Query, PostGIS Day, Multiple PgBouncers | Scaling Postgres 242 11:38

1 Postgres 15.1, Postres 10 Retrospective, Reducing Replication Lag, Listen & Notify | Scaling Postgres 241 17:53


1 Shared Buffers, Compression Algorithm, Merge Command, Postgres Contributions | Scaling Postgres 239 15:18


1 Postgres 15 Released, File Systems, Connection Pooling, Secure Connections | Scaling Postgres 237 18:53


1 Postgres 15 RC1, ICU Collations, Listen & Notify, Understanding TOAST | Scaling Postgres 235 16:21

1 Rust for Extensions, Timescale vs. Postgres, Uninterrupted Sharding, Data Flow | Scaling Postgres 234 16:20

1 Useful Features, Community Blogging, PG 15 Anticipation, Generic Plans | Scaling Postgres 233 13:43


1 PG15 Public Schema, Kubernetes Experiences, Dump Manifests, PgBouncer Fork | Scaling Postgres 231 19:03

1 Stats Collector Gone, Handling Latency, PG In The Browser, Future High Availability | Scaling Postgres 230 12:33


1 New Postgres Releases, Privilege Escalation CVE, Chaos Testing, High Availability | Scaling Postgres 228 12:45

1 Researching Performance, Postgres Survey, pgAdmin Survey, Long Running Queries | Scaling Postgres 227 8:53

1 SQL Functions, Explain Analyze Buffers, Debug Autovacuum, RLS Multi-Tenancy | Scaling Postgres 226 16:19
Ласкаво просимо до Player FM!
Player FM сканує Інтернет для отримання високоякісних подкастів, щоб ви могли насолоджуватися ними зараз. Це найкращий додаток для подкастів, який працює на Android, iPhone і веб-сторінці. Реєстрація для синхронізації підписок між пристроями.