Scaling Postgres Episode 76 | New CVEs | Postgres Programming | JSONB | Advisory Locks

preview_player
Показать описание
To get the show notes as well as get notified of new episodes, visit:

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?

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
  1. Scaling Postgres
  2. PostgreSQL
  3. Scaling PostgreSQL
  4. PostgreSQL Performance
Рекомендации по теме
Scaling Postgres Episode 0:12:55

Scaling Postgres Episode 76 | New CVEs | Postgres Programming | JSONB | Advisory Locks

Scaling Postgres Episode 0:17:37

Scaling Postgres Episode 78 Efficient Pagination | Rotating Passwords | BRIN | Row Level Security

Scaling Postgres Episode 0:12:15

Scaling Postgres Episode 77 | Timeseries Queries | Arrays | Ranges | C Triggers

Scaling Postgres Episode 0:11:12

Scaling Postgres Episode 74 | Picturing Vacuum | Recovery Changes | Cert Auth | Function Replication

Scaling Postgres Episode 0:17:11

Scaling Postgres Episode 72 | Collation Issues | Fast Loading | Recovery | SCRAM Authentication

Scaling Postgres Episode 0:17:45

Scaling Postgres Episode 1 | Petabyte Scale and Locking

Scaling Postgres Episode 0:14:55

Scaling Postgres Episode 191: Man-In-The-Middle, pg_auto_failover, Less Known Features, LZ4 Compress

Scaling Postgres Episode 0:16:34

Scaling Postgres Episode 217 Schema Change Mistakes, Canceling Statements, pg_rman, Pedantry Removal

Scaling Postgres Episode 0:17:48

Scaling Postgres Episode 222 PG 15 Beta 2, Concerning Locks, Vacuum Tuning, Transaction Anomalies

Integer Overflow, User-Friendly 0:17:44

Integer Overflow, User-Friendly Permissions, Dump & Logical Replication | Scaling Postgres 255

LZ4 & ZSTD 0:19:15

LZ4 & ZSTD Compression, Avoid Problems, Triggers Simplify, Indexes Can Hurt | Scaling Postgres 2...

Advanced use of 0:43:37

Advanced use of pg_stat_statements: Filtering, Regression Testing & More

Benchmark Azure Cosmos 1:00:17

Benchmark Azure Cosmos DB with Benchmarking Framework for Azure Databases - Ep 76

Deepdive in Postgres 0:59:51

Deepdive in Postgres jsonb type

What to consider 0:00:58

What to consider when building for scale

How PostgreSQL Extension 0:42:16

How PostgreSQL Extension APIs are Changing the Face of Relational Databases

What is Keptn 1:03:25

What is Keptn Lifecycle Toolkit - with Giovanni Liva

Hydra: Supercharge your 0:05:27

Hydra: Supercharge your Analytics on Postgres

A better alternative 0:05:06

A better alternative to SELECT FOR UPDATE

5mins of Postgres 0:05:44

5mins of Postgres E12: The basics of tuning VACUUM and autovacuum in Postgres

Webinar: Security and 0:53:34

Webinar: Security and Containers in Cloud Native PostgreSQL

Diving Deep into 0:26:06

Diving Deep into Sensor Data with TimescaleDB | Episode #4: Policies for Compression and Retention

What's next for 3:00:11

What's next for enterprise architects and developers

PostgreSQL as a 0:07:59

PostgreSQL as a Vector Database: Part 3, Making Postgres Distributed and Scalable