To get the show notes as well as get notified of new episodes, visit:
[ Ссылка ]

In this episode of Scaling Postgres, we discuss one cause of broken indexes, Postgres trademark issues, percentiles vs. averages and logical replication improvements.

Want to learn more about Postgres performance?
Join my FREE mini-course called the PostgreSQL Performance Starter Kit here: [ Ссылка ]

Timestamps:
00:00 - Intro
00:29 - PostgreSQL 14 RC 1 Released!
01:27 - Postgres 14: It's The Little Things
03:27 - A better way to index your Postgres database: pganalyze Index Advisor
05:24 - when you have millions of insert statements in a file...
06:50 - Restarting a sequence: how hard could it be? (PostgreSQL and Oracle)
08:49 - Building an Oracle to PostgreSQL migrator: Lessons learned
10:54 - Pgpool-II Configuration Parameters - reserved_connections
11:17 - Pgpool-II Configuration Parameters - enable_shared_relcache
11:33 - Michael Goldberg
11:44 - Rubber Duck Dev Show Episode 14 | Background Job Processing
12:13 - Outro

#postgres #postgresql

свернуть