Scaling Postgres Episode 75 | Combining Indexes | Regular Expressions | Parallelism | PostGIS
Автор: Scaling Postgres
Загружено: 2019-08-04
Просмотров: 296
To get the show notes as well as get notified of new episodes, visit:
https://www.scalingpostgres.com/episo...
In this episode of Scaling Postgres, we discuss combining indexes, regular expressions, parallelism in Postgres and PostGIS content.
Want to learn more about Postgres performance?
Join my FREE mini-course called the PostgreSQL Performance Starter Kit here: https://www.scalingpostgres.com/cours...
Timestamps:
00:00 - Intro
00:23 - Combined indexes vs. separate indexes in PostgreSQL
04:13 - PostgreSQL: Regular expressions and pattern matching
05:14 - Parallelism in PostgreSQL
08:41 - How to Adjust Linux Out-Of-Memory Killer Settings for PostgreSQL
09:46 - PostgreSQL: Simple C extension Development for a Novice User (and Performance Advantages)
11:02 - Using plpgsql_check to Find Compilation Errors and Profile Functions
12:09 - Postgres 12 highlight - Replication slot copy
13:21 - Waiting for PostgreSQL 13 – Add support for –jobs in reindexdb
13:59 - PostGIS Overlays
14:25 - Simple SQL GIS
14:57 - Waiting for PostGIS 3: ST_AsMVT Performance
15:16 - Outro
#postgres #postgresql
Доступные форматы для скачивания:
Скачать видео mp4
-
Информация по загрузке:
