Scaling Postgres Episode 8 | Scaling Real-Time Analytics | Covering Indexes | 1,500 Upgrades

Показать описание

To get the show notes as well as get notified of new episodes, visit:

In this episode of Scaling Postgres, we review articles covering real-time analytics at scale, covering indexes in Postgres 11, 1,500 Postgres upgrades and PostgreSQL vs. MySQL.

Want to learn more about Postgres performance?

Timestamps:
00:00 - Intro
00:37 - Building Real Time Analytics APIs at Scale
03:24 - Postgres 11 highlight - Covering Indexes
05:26 - idle_in_transaction_session_timeout: Terminating idle transactions in PostgreSQL
07:01 - Get rid of your unused indexes!
07:54 - PostgreSQL Bloatbusters.
08:58 - PostgreSQL Data Types: Date, Timestamp, and Time Zones
10:19 - The Ultimate Postgres vs MySQL Blog Post
11:14 - Postgres 10 Upgrade
12:15 - How to Perform Failover with the PostgreSQL Kubernetes Operator
13:10 - PostgreSQL Replication Failback with pg_rewind
14:40 - Outro

#postgres #postgresq

Рекомендации по теме

Scaling Postgres Episode 8 | Scaling Real-Time Analytics | Covering Indexes | 1,500 Upgrades

Scaling Postgres Episode 8 | Scaling Real-Time Analytics | Covering Indexes | 1,500 Upgrades

Scaling Postgres Episode 78 Efficient Pagination | Rotating Passwords | BRIN | Row Level Security

Scaling Postgres Episode 7 | Any Scale | Monitoring Vacuum | Copy | Annotated Config

Kubernetes Native Data Service: Scale Up a PostgreSQL Instance | Episode 8

Scaling Postgres Episode 37 | Postgres Goodies | Materialized vs Rollup | Column Oriented

Scaling Postgres Episode 163 SQL Data Analysis | pgBouncer Setup | Understanding Deadlocks | Tuning

Scaling Postgres Episode 164 Random Rows | Fast Distinct | Temp vs Unlogged | Terminate Connections

Data Skew, Monitoring, Remote Access CSV, Documentation | Scaling Postgres 270

UUID vs Bigint Battle!!! | Scaling Postgres 302

Scaling Postgres Episode 108 Ten Things | Audit Triggers | Schema Design | High Availability

Scaling Postgres Episode 203 Saving Space, Working with TOAST, Protecting Data, High CPU Utilization

Scaling Postgres Episode 32 | Sysadmin Concerns | Power of Indexing | pgbouncer Monitoring

Scaling Postgres Episode 228 Postgres Releases, Privilege Escalation, Chaos Tests, High Availability

Scaling Postgres Episode 221 psql Shortcuts, Debugging Deadlocks, Find & Stop Queries, Using SCR...

Scaling Postgres Episode 74 | Picturing Vacuum | Recovery Changes | Cert Auth | Function Replication

Scaling Postgres Episode 208 pgbouncer, Query Parameter Types, Lateral Joins, Security Invoker Views

Scaling Postgres Episode 145 PgMiner Botnet | Collation Index Corruption | Custom Data Types

Scaling Postgres Episode 138 Connection Scaling | TimescaleDB | Time-series Gaps | Red & Gold Si...

Scaling Postgres Episode 200 5 Minutes of Postgres | Unnest | SCRAM | Multi-master Review

Faster Copy, psql Variables, backup_label, Bad Encoding | Scaling Postgres 268

Scaling Postgres Episode 5 | Constraints | User Order | PG Terrible | Logical Upgrades

Scaling Postgres Episode 226 SQL Functions, Explain Buffers, Debug Autovacuum, RLS Multi-Tenancy

Scaling Postgres Episode 153 Int to BigInt | Resistance is Futile | Optimizer Statistics

Scaling Postgres Episode 127 Recursive Queries | Lateral Joins | Pagination | JSONB Arrays