Will Postgres Pull A Redis? | Scaling Postgres 309

Рет қаралды 2,636

Күн бұрын

To get the show notes as well as get notified of new episodes, visit:
www.scalingpostgres.com/episo...
In this episode of Scaling Postgres, we discuss whether Postgres will pull a Redis, remembering Simon Riggs, built-in collation provider and C.UTF-8 in PG 17 and health checks.
Want to learn more about Postgres performance?
Join my FREE mini-course called the PostgreSQL Performance Starter Kit here: www.scalingpostgres.com/cours...
Timestamps:
00:00 - Intro
00:19 - Will PostgreSQL ever change its license?
03:41 - Remembering Simon Riggs
04:51 - Waiting for Postgres 17: The new built-in C.UTF-8 locale
07:12 - Health check
08:04 - Best pg_basebackup compression settings for v15 and above
08:40 - Recovering Deleted Data From PostgreSQL Tables
10:31 - 2024-03-25 SCaLE 21x - Recovering from Data Loss Despite Not Having a Backup: - A Postgres True Story
11:37 - PostgreSQL 17: Convert a physical replica to a logical replica using pg_createsubscriber
12:05 - Checking Your Privileges
13:24 - CloudNativePG Recipe 4 - Connecting to Your PostgreSQL Cluster with pgAdmin4
13:43 - CloudNativePG Recipe 5 - How to migrate your PostgreSQL database in Kubernetes - with ~0 downtime from anywhere
14:10 - Major Developments in Postgres Extension Discovery and Distribution
14:48 - Outro
#postgres #postgresql

Пікірлер: 11

@JimmyAngelakos 3 ай бұрын

Thanks for the tribute to Simon and 2ndQ, also for your kind words about my talk! Love your channel.

@ScalingPostgres 3 ай бұрын

No problem! I get a lot out of your content as well.

@JohnBurwell 3 ай бұрын

Unlike Terraform and Redis, the rights to PostgreSQL are owned by a non-profit. Not only do they lack the profit driver to change the license, a license change would require agreement across a majority of that organization's governing body to change the license. This governance is one of the many reasons why open source projects owned/managed by non-profit foundations are preferable to open source products owned by for-profit companies.

@craigslist6988 3 ай бұрын

That argument sounded a lot better before OpenAI..