Neues vom PostgreSQL Planet

Neues vom PostgreSQL Planet Feed abonnieren
Planet PostgreSQL
Aktualisiert: vor 2 Stunden 14 Sekunden

Lætitia AVROT: PG Lord of the Ring

12. August 2025 - 2:00
I’ve used PostgreSQL for almost 20 years. During this time, I’ve struggled with its official clients. Normally, I have a good memory (except for people’s names and faces). So having to refer to the tool documentation each time I wanted to use it was very unusual for me. So I asked myself, why is that so? I noticed that there was inconsistency and even incompatibility among flags. Sometimes you need the -d flag for the database name.

Craig Kerstiens: Indexing JSONB in Postgres

11. August 2025 - 19:00

Postgres is amazing for many reasons. One area that doesn't get near enough attention is datatypes. Postgres has a rich set of datatypes and one important one for devs to be especially excited about is JSONB.

JSONB which is structured and indexable. In JSON, the B stands for binary (or as we like to think of it B is for better), which means data is pre-parsed as it is stored. How do you get the most out of JSONB from a retrieval perspective? Enter Postgres' rich indexing support.

Andreas 'ads' Scherbaum: Curt Kolovson

11. August 2025 - 16:00
PostgreSQL Person of the Week Interview with Curt Kolovson: I grew up in the Boston area. I currently live in the San Francisco Bay Area and have resided here for over 40 years.

Seiten