Загрузка...

Are You Hurting Your Performance? | Scaling Postgres 371

To get the show notes as well as get notified of new episodes, visit:
https://www.scalingpostgres.com/episodes/371-are-you-hurting-your-performance/

In this episode of Scaling Postgres, we discuss how you use the database can impact its performance, performance of pg_search, fast uploads and some downsides of different upgrade methods.

Want to learn more about Postgres performance?
Join my FREE training called Postgres Performance Demystified here: https://www.scalingpostgres.com/courses/postgres-performance-demystified/

Timestamps:
00:43 - SELECT FOR UPDATE considered harmful in PostgreSQL
02:58 - Comparing Native Postgres, ElasticSearch, and pg_search for Full-Text Search
06:00 - The (Non-) Effect of Primary Keys on Bulk Data Load Performance
07:45 - PostgreSQL and Ducks: The Perfect Analytical Pairing
11:45 - PostgreSQL active-active replication, do you really need it?
13:54 - Preserve optimizer statistics during major upgrades with PostgreSQL v18
15:08 - How I Dropped the Production Database on a Friday Night
16:30 - Mean vs p99
18:00 - PGConf.dev 2025 YouTube Playlist
18:10 - Speed Without Sacrifice: Building the Modern PostgreSQL for the Analytical and Agentic Era
18:45 - Consulting Corner
20:49 - Outro

#postgres #postgresql

Видео Are You Hurting Your Performance? | Scaling Postgres 371 канала Scaling Postgres
PostgreSQL Scaling PostgreSQL PostgreSQL Performance
Комментарии отсутствуют
Зарегистрируйтесь или войдите с
Информация о видео
23 июня 2025 г. 2:00:46
00:21:10
Scaling Postgres
Теги
Правообладателям
Жалоба на материал Недопустимый материал Нарушение авторских прав
Комментарии
Поделиться
Другие видео канала

Vacuum Is Lying To You? | Scaling Postgres 397Vacuum Is Lying To You? | Scaling Postgres 397

15% - 250% Faster Query Throughput | Scaling Postgres 28715% - 250% Faster Query Throughput | Scaling Postgres 287

Scaling Postgres Episode 219 Out-Of-Cycle Release, Should You Upgrade, Survey, Automatic IndexingScaling Postgres Episode 219 Out-Of-Cycle Release, Should You Upgrade, Survey, Automatic Indexing

PGlite: Embeddable Postgres & postgres.new | Scaling Postgres 329PGlite: Embeddable Postgres & postgres.new | Scaling Postgres 329

Scaling Postgres Episode 223 DB Decomposition, Fast Text Search, Understanding pg_stat_activityScaling 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 ImpactScaling Postgres Episode 147 DBMS of the Year | Better Data Migrations | Idle Connection Impact

Scaling Postgres Episode 28 | Watch | Fast Text Search | Column Defaults | Import CSVsScaling Postgres Episode 28 | Watch | Fast Text Search | Column Defaults | Import CSVs

Scaling Postgres Episode 88 Partitioning | Logical Replication Upgrade | Columnar Compress | HAProxyScaling Postgres Episode 88 Partitioning | Logical Replication Upgrade | Columnar Compress | HAProxy

11 Security Issues | Scaling Postgres 41711 Security Issues | Scaling Postgres 417

The Future of Postgres Architecture | Scaling Postgres 372The Future of Postgres Architecture | Scaling Postgres 372

Easy Incremental Data Processing? | Scaling Postgres 347Easy Incremental Data Processing? | Scaling Postgres 347

Seven Years of Scaling Postgres | Scaling Postgres 350Seven Years of Scaling Postgres | Scaling Postgres 350

Scaling Postgres Episode 224 Column Performance, BRIN Win, Unique and Null, Parallel DistinctScaling Postgres Episode 224 Column Performance, BRIN Win, Unique and Null, Parallel Distinct

HNSW Indexes, Vacuuming Bloat, Watch Me Now, Connections | Scaling Postgres 281HNSW Indexes, Vacuuming Bloat, Watch Me Now, Connections | Scaling Postgres 281

Storage Engine Progress? | Scaling Postgres 380Storage Engine Progress? | Scaling Postgres 380

Table Lock Explosion! | Scaling Postgres 391Table Lock Explosion! | Scaling Postgres 391

Postgres 17 Beta 1 Released | Scaling Postgres 318Postgres 17 Beta 1 Released | Scaling Postgres 318

Do You Need A Vectorizer? | Scaling Postgres 340Do You Need A Vectorizer? | Scaling Postgres 340

When Postgres Development Stopped! | Scaling Postgres 319When Postgres Development Stopped! | Scaling Postgres 319

Handle One Million Connections? | Scaling Postgres 360Handle One Million Connections? | Scaling Postgres 360

Scaling Postgres Episode 95 max_locks_per_transaction | Logical Replication | Backup & RecoveryScaling Postgres Episode 95 max_locks_per_transaction | Logical Replication | Backup & Recovery

Яндекс.Метрика
© 2008-2026 «Информационно-развлекательный портал города Верхняя Салда»
salda.ws@mail.ru salda_ws Контакты Карта портала Сообщить об ошибке Соглашения Пользовательское соглашение Соглашение о конфиденциальности Согласие на обработку персональных данных Информация для правообладателей Об использовании Cookies
Все заметки Новая заметка Страницу в заметки
Страницу в закладки Мои закладки
На информационно-развлекательном портале SALDA.WS применяются cookie-файлы. Нажимая кнопку Принять, вы подтверждаете свое согласие на их использование.
О CookiesНапомнить позжеПринять