Scaling Postgres Episode 76 | New CVEs | Postgres Programming | JSONB | Advisory Locks
Автор: Scaling Postgres
Загружено: 2019-08-11
Просмотров: 936
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 new CVEs, programming Postgres, JSONB comparison and using advisory locks.
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 - PostgreSQL 11.5, 10.10, 9.6.15, 9.5.19, 9.4.24, and 12 Beta 3 Released!
01:26 - Postgres is the coolest database – Reason #5: It can not be bought out
02:51 - Overview of Server-Side Programming in PostgreSQL
07:27 - Comparing Postgres JSONB with NoSQL
08:19 - Postgres 12 highlight - SQL/JSON path
08:50 - Postgres Advisory Locks with asyncio
09:37 - Doubling the Sorting Speed of Postgres Network Types with Abbreviated Keys
10:24 - Automatically updating materialized views
11:04 - PostgreSQL Graph Search Practices - 10 Billion-Scale Graph with Millisecond Response
11:54 - Waiting for PostGIS 3: Separate Raster Extension
12:29 - Outro
#postgres #postgresql
Доступные форматы для скачивания:
Скачать видео mp4
-
Информация по загрузке:
