Neues vom PostgreSQL Planet

Neues vom PostgreSQL Planet Feed abonnieren
Planet PostgreSQL
Aktualisiert: vor 2 Stunden 29 Minuten

Andreas 'ads' Scherbaum: Dilip Kumar

1. Juli 2024 - 16:00
PostgreSQL Person of the Week Interview with Dilip Kumar: My name is Dilip Kumar, and I reside in Bangalore, India. I am recognized as a PostgreSQL contributor, having made significant contributions to the core features of the PostgreSQL open-source project, mainly in areas of Parallel Query, Logical replication, Performance improvements, and SLRU.

Karen Jex: How Postgres is Misused and Abused in the Wild

1. Juli 2024 - 10:22

This post contains the slides from the talk that I gave at in Vancouver a few weeks ago, together with the transcript and other information.

This is my new approach to sharing slides, inspired by Simon Willison's annotated presentations.

You can also watch the video here.

Andrei Lepikhov: Elaboration of the PostgreSQL sort cost model

1. Juli 2024 - 3:32

This post debates the current sort cost model, identifies its shortcomings, and proposes a new, more comprehensive model that expands the scope of the optimiser search. Designing this post for developers, we've intentionally used terminology derived from PostgreSQL internal code, which may sometimes be unclear to newcomers.

Andrew Atkinson: Mastering PostgreSQL for Rails: An Interview with Andy Atkinson

1. Juli 2024 - 2:00

Hey there! My book High Performance PostgreSQL for Rails just went into print last week!

As part of celebrating this milestone, we’ve got a series of promotional appearances lined up to explore Ruby on Rails and PostgreSQL in general and help explain why prospective readers may benefit from the book.

To kick things off, I recently met with Phil Smy who runs a popular YouTube channel with videos on Ruby on Rails and more.

Christoph Schiessl: Using Transaction Chaining to Reduce Server Round-Trips

28. Juni 2024 - 2:00
Cut the number of required PostgreSQL server round-trips by up to 50% using the `AND CHAIN` parameter of the `COMMIT` and `ROLLBACK` statements.

David Wheeler: Patch: Postgres ABI and API Guidance

27. Juni 2024 - 20:05

TL;DR: If you’re a Postgres extension developer interested in understanding what to expect from core API and ABI stability, please review and give feedback on this patch (or pull request) adding ABI and API Guidance to the documentation.

Grant Fritchey: Data Technology Learning Resources

27. Juni 2024 - 15:37

Hey all! Quick one here. Tracy Boggiano, awesome person that she is, has put together an interesting collection of data over on GitHub. It’s titled DBA Resources, but it goes beyond DBAs. It’s much more about the different data platforms on display. And, it’s in Github. Create a pull request and you can add to […]

The post Data Technology Learning Resources appeared first on Grant Fritchey.

Gabriele Bartolini: Making the world my single point of failure with PostgreSQL

27. Juni 2024 - 9:30

The upcoming CloudNativePG 1.24 introduces a game-changing feature: the ability to declaratively manage PostgreSQL cluster switchover across cloud regions or different Kubernetes clusters. This advancement enables the seamless demotion of a primary cluster and the promotion of a replica cluster in another region without the need to re-clone the former primary. This innovation significantly revolutionises database management practices, enhancing efficiency and reliability in multi-region and multi-cluster environments.

Christoph Schiessl: Repairing Corrupted Indexes with `REINDEX`ing

27. Juni 2024 - 2:00
This article outlines how to rebuild indexes with `REINDEX`. As an example, we will deliberately corrupt an index for a column that uses a custom `ENUM` column.

Dian Fay: ST_MapAlgebra and Tiled Rasters

27. Juni 2024 - 2:00

Let's say you have two rasters, and you want to combine them with some extra value math -- perhaps you want to grade grassland around 50°N 100°E by latitude and elevation, so blue to green to red the more northerly or higher up the point. ST_MapAlgebra to the rescue!

Andrei Lepikhov: PostgreSQL Sort estimation volnurability

26. Juni 2024 - 4:36

As a PostgreSQL developer, I am inevitably stumbling across some weak points in the code. I’m not sure alternative DBMSes manage that much better, but knowledge about possible issues may help in the long run.

This time, I encountered quite a subtle issue - incremental sort estimation instability.

Luca Ferrari: pg_dump and --if-exists little gem

26. Juni 2024 - 2:00

An option I was not aware of…

pg_dump and –if-exists little gem

pg_dump is a very useful tool to dump (and hence prepare to restore) a single PostgreSQL database.

When I use it, I usually add the options:

David Wheeler: 2024

25. Juni 2024 - 23:41

In addition to the afore-blogged Extension Summit, I also attended a slew of the regular sessions, gave a talk on the future of the extension ecosystem, socialized with extension authors and core developers, and joined discussions in a number of unconference sessions. Some notes on selected talks and events:

Gabriele Bartolini: Kubernetes Just Turned Ten: Where Does PostgreSQL Stand?

25. Juni 2024 - 15:46

As Kubernetes marks its tenth anniversary, its influence on infrastructure management continues to grow. This article examines the increasing adoption of PostgreSQL within Kubernetes, fueled by its extensibility and AI applications. It highlights the journey of integrating PostgreSQL with Kubernetes, focusing on the CloudNativePG operator. A comparison between Kubernetes and traditional VM deployments underscores the advantages for database workloads.


25. Juni 2024 - 7:21
© Laurenz Albe 2024

Enough has been written about the connection between VACUUM, the visibility map and index-only scans in PostgreSQL. But recently I demonstrated index-only scans to a class I was teaching and made some observations that surprised me at first. I could eventually explain what I saw, but I may have given the class more to chew on than I intended.

Peter Eisentraut: PostgreSQL performance with different compilers

25. Juni 2024 - 6:00

I have tested several times which compiler builds PostgreSQL the fastest. Now let’s look at with which compiler PostgreSQL runs the fastest.

Andreas 'ads' Scherbaum: Derk van Veen

24. Juni 2024 - 16:00
PostgreSQL Person of the Week Interview with Derk van Veen: I was born in Zoeterwoude (Netherlands), a small village close to Leiden, where Floor Drees was born. Leiden is where I went to secondary school.

Jobin Augustine: Upgrading to the New Etcd Version From 3.3 for Patroni

24. Juni 2024 - 15:20
We have been promoting and using Patroni as the best high availability framework for PostgreSQL, and Etcd was the preferred/recommended DCS for the Patroni cluster. Both Patroni and Etcd have been part of PostgreSQL distribution from Percona for years now. But one area where we were stuck was the Etcd version, and we continued to […]

Steven Miller: What you should know about JSON web tokens

24. Juni 2024 - 11:00
This post contained content that could not be rendered in the Atom feed. Please use the official post link:

Karen Jex: When I grow up I want to be a Database Administrator (said no-one ever)

23. Juni 2024 - 23:40

Instead of just sharing the slides from the keynote talk that I gave at DjangoCon Europe 2024 in Vigo this month, I'm trying a new approach, inspired by Simon Willison's annotated presentations. This post contains the slides together with the transcript, links etc. so it should be much more useful.

I'll add a link to the video as soon as it's available.