Scaling Postgres Episode 72 | Collation Issues | Fast Loading | Recovery | SCRAM Authentication
To get the show notes as well as get notified of new episodes, visit:
https://www.scalingpostgres.com/episodes/72-collation-issues-fast-loading-recovery-scram-authentication/
In this episode of Scaling Postgres, we discuss collation issues, how to load data quickly, recovery changes in Postgres 12 and moving to SCRAM authentication.
Want to learn more about Postgres performance?
Join my FREE mini-course called the PostgreSQL Performance Starter Kit here: https://www.scalingpostgres.com/courses/postgresql-performance-starter-kit/
Timestamps:
00:00 - Intro
00:23 - ICU collations against glibc 2.28 data corruption
01:45 - Beware of your next glibc upgrade
03:54 - Fastest Way to Load Data Into PostgreSQL Using Python
05:24 - Fast PostgreSQL Data Loading Using Ruby
05:51 - Big News In Databases — Summer 2019
07:31 - PostgreSQL & recovery.conf
08:47 - How to Upgrade Your PostgreSQL Passwords to SCRAM
10:46 - [YouTube] ITPUG Italian PostgreSQL Users Group Channel
11:27 - Implementing Autonomous Transactions in Postgres
12:40 - Asynchronous Notification
13:06 - The database deficit: how full-stack developers’ blind spot harms agile teams
14:12 - PostgreSQL WAL Retention and Clean Up: pg_archivecleanup
15:20 - Generate Primary Keys (almost) Automatically
16:29 - Serving Dynamic Vector Tiles from PostGIS
16:46 - Outro
#postgres #postgresql
Видео Scaling Postgres Episode 72 | Collation Issues | Fast Loading | Recovery | SCRAM Authentication канала Scaling Postgres
https://www.scalingpostgres.com/episodes/72-collation-issues-fast-loading-recovery-scram-authentication/
In this episode of Scaling Postgres, we discuss collation issues, how to load data quickly, recovery changes in Postgres 12 and moving to SCRAM authentication.
Want to learn more about Postgres performance?
Join my FREE mini-course called the PostgreSQL Performance Starter Kit here: https://www.scalingpostgres.com/courses/postgresql-performance-starter-kit/
Timestamps:
00:00 - Intro
00:23 - ICU collations against glibc 2.28 data corruption
01:45 - Beware of your next glibc upgrade
03:54 - Fastest Way to Load Data Into PostgreSQL Using Python
05:24 - Fast PostgreSQL Data Loading Using Ruby
05:51 - Big News In Databases — Summer 2019
07:31 - PostgreSQL & recovery.conf
08:47 - How to Upgrade Your PostgreSQL Passwords to SCRAM
10:46 - [YouTube] ITPUG Italian PostgreSQL Users Group Channel
11:27 - Implementing Autonomous Transactions in Postgres
12:40 - Asynchronous Notification
13:06 - The database deficit: how full-stack developers’ blind spot harms agile teams
14:12 - PostgreSQL WAL Retention and Clean Up: pg_archivecleanup
15:20 - Generate Primary Keys (almost) Automatically
16:29 - Serving Dynamic Vector Tiles from PostGIS
16:46 - Outro
#postgres #postgresql
Видео Scaling Postgres Episode 72 | Collation Issues | Fast Loading | Recovery | SCRAM Authentication канала Scaling Postgres
Комментарии отсутствуют
Информация о видео
15 июля 2019 г. 5:30:37
00:17:11
Другие видео канала
Scaling Postgres Episode 15 | Leveraging Postgres | Tuning Autovacuum | Slow Queries
15% - 250% Faster Query Throughput | Scaling Postgres 287
Scaling Postgres Episode 219 Out-Of-Cycle Release, Should You Upgrade, Survey, Automatic Indexing
PGlite: Embeddable Postgres & postgres.new | Scaling Postgres 329
Scaling Postgres Episode 223 DB Decomposition, Fast Text Search, Understanding pg_stat_activity
Scaling Postgres Episode 147 DBMS of the Year | Better Data Migrations | Idle Connection Impact
Scaling Postgres Episode 28 | Watch | Fast Text Search | Column Defaults | Import CSVs
Scaling Postgres Episode 88 Partitioning | Logical Replication Upgrade | Columnar Compress | HAProxy
Scaling Postgres Episode 83 Postgres 12 | Window Frames | Index Types | Synchronous Replication
Easy Incremental Data Processing? | Scaling Postgres 347
Seven Years of Scaling Postgres | Scaling Postgres 350
Scaling Postgres Episode 224 Column Performance, BRIN Win, Unique and Null, Parallel Distinct
HNSW Indexes, Vacuuming Bloat, Watch Me Now, Connections | Scaling Postgres 281
Scaling Postgres Episode 243 IN vs ANY, Ghost Conditions, Percentage Calculations, Variadic Unnest
pg_stat_statements, Transaction ID Wraparound, Consultant Knowledge, CitusCon | Scaling Postgres 265
Postgres 17 Beta 1 Released | Scaling Postgres 318
Do You Need A Vectorizer? | Scaling Postgres 340
When Postgres Development Stopped! | Scaling Postgres 319
Handle One Million Connections? | Scaling Postgres 360
Scaling Postgres Episode 95 max_locks_per_transaction | Logical Replication | Backup & Recovery