Scaling Postgres Episode 29 | Parallel Indexing | SQL vs. ORM | Logical Replication Upgrades

preview_player
Показать описание
To get the show notes as well as get notified of new episodes, visit:

In this episode of Scaling Postgres, we review articles covering parallel indexing, SQL vs. ORM, logical replication upgrades and development DBs.

Want to learn more about Postgres performance?

Timestamps:
00:00 - Intro
00:24 - PostgreSQL: Parallel CREATE INDEX for better performance
03:13 - I don't want to learn your garbage query language
05:14 - Upgrading to PostgreSQL 11 with Logical Replication
06:56 - 12 Factor: Dev/prod parity for your database
09:23 - Why do we install as root?
10:31 - CHAR: What is it good for?
11:15 - Tuning PostgreSQL Database Parameters to Optimize Performance
13:04 - Outro

#postgres #postgresql
  1. Scaling Postgres
  2. PostgreSQL
  3. Scaling PostgreSQL
  4. PostgreSQL Performance
Рекомендации по теме
Scaling Postgres Episode 0:13:28

Scaling Postgres Episode 29 | Parallel Indexing | SQL vs. ORM | Logical Replication Upgrades

Scaling Postgres Episode 0:09:46

Scaling Postgres Episode 30 | Parallelism | JIT Compiling | Indexes | Administration

Scaling Postgres Episode 0:15:30

Scaling Postgres Episode 54 | Index-Only Scans | Lock Table | Hot Standby Feedback | Large Backups

Scaling Postgres Episode 0:15:27

Scaling Postgres Episode 189 Index Downsides | TCP Keep Alive | Develop Postgres | Learning PL/pgSQL

Scaling Postgres Episode 0:15:46

Scaling Postgres Episode 31 | CTE Warning | PG 11 Features | Death by DB | Correlation

Scaling Postgres Episode 0:18:11

Scaling Postgres Episode 151 Cleaning | Function Performance | 11 Million IOPS | Change Data Capture

Scaling Postgres Episode 0:14:26

Scaling Postgres Episode 247 Generate Test Data, Faster Archiving, Date Statistics, Useless Indexes

Scaling Postgres Episode 0:18:05

Scaling Postgres Episode 27 | Multiple Databases | Slow Queries | Sorting Performance

Scaling Postgres Episode 0:09:13

Scaling Postgres Episode 33 | Per-Table Autovacuum | FDW Synchronization | Distinct On

Scaling Postgres Episode 0:19:30

Scaling Postgres Episode 214 Backup Compression, Postgres IO, Parquet Files, pg_stat_monitor

Scaling Postgres Episode 0:15:06

Scaling Postgres Episode 187 Sharding | Federation | Linux HugePages | Performance Tuning

Scaling Postgres Episode 0:11:59

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

Scaling Postgres Episode 0:17:36

Scaling Postgres Episode 117 Index Deduplication | Fast Hierarchy | More Monitoring | Cloud-Native

Build A GPT 0:12:22

Build A GPT In SQL | Scaling Postgres 299

Scaling Postgres Episode 0:09:05

Scaling Postgres Episode 93 Logical Replication | Monitoring Queries | SQL Beautifier

Scaling Postgres Episode 0:14:43

Scaling Postgres Episode 48 | Microsoft Acquires Citus Data | Split WAL | Maintenance Work Memory

Scaling Postgres Episode 0:14:38

Scaling Postgres Episode 232 PG15 Beta 4, Primary Key Options, Sequence Limits, Configuration

Postgres Releases, PostgreSQL 0:19:05

Postgres Releases, PostgreSQL Survey, Partitioning vs. Sharding, Bulk Loading | Scaling Postgres 277

Scaling Postgres Episode 0:16:34

Scaling Postgres Episode 217 Schema Change Mistakes, Canceling Statements, pg_rman, Pedantry Removal

Scaling Postgres Episode 0:18:41

Scaling Postgres Episode 157 auto_explain Overhead | Postgres Data Lake | Citus Shard Balance | SSL

Postgres 16 Released, 0:14:01

Postgres 16 Released, Postgres Meme, File vs base64 Strings, Citus Sharding | Scaling Postgres 282

Scaling Postgres Episode 0:09:55

Scaling Postgres Episode 38 | Parallel Query | Real Time Analytics | Killed Index Tuples

Scaling Postgres Episode 0:21:20

Scaling Postgres Episode 185 Postgres 14 Released | Using JSON | Not Using Indexes | Sequence Gaps

Scaling Postgres Episode 0:14:04

Scaling Postgres Episode 250 Performance Issue, Survive Without Superuser, Reserved Connections