Sammlung von Newsfeeds

Pavlo Golub: Grafana dashboard for pg_timetable scheduled jobs

Neues vom PostgreSQL Planet - 23. Januar 2024 - 16:34

As a little boy, I dreamed of becoming a supersonic jet pilot or an astronaut. I also yearned to pilot trains, subways, trolleybuses, trams, and other vessels. I remember stealing pot lids from my grandparent’s kitchen to make a steering wheel. And also all sorts of devices and tools to emulate the cockpit dashboard. My childish mind easily turned a hammer into a landing gear release lever. Clothes pegs quickly served as switches to open the airlocks.

Hans-Juergen Schoenig: PostgreSQL: Why true Open Source matters

Neues vom PostgreSQL Planet - 23. Januar 2024 - 10:24

PGConfEU2023 is over and a New Year has started. For those who did not manage to make it to Prague to attend the conference, I wanted to use the occasion, to sum up what I tried to communicate during my keynote session and reflect a bit on the importance of true Open Source versus Closed Source as well as on subscription services.

Longevity in data processing

David Wheeler: I’m a Postgres Extensions Tembonaut

Neues vom PostgreSQL Planet - 22. Januar 2024 - 18:00

New year, new job.

I’m pleased to announce that I started a new job on January 2 at Tembo, a fully-managed PostgreSQL developer platform. Tembo blogged the news, too.

Hubert 'depesz' Lubaczewski: Waiting for PostgreSQL 17 – In plpgsql, allow %TYPE and %ROWTYPE to be followed by array decoration.

Neues vom PostgreSQL Planet - 22. Januar 2024 - 12:36
On 4th of January 2024, Tom Lane committed patch: In plpgsql, allow %TYPE and %ROWTYPE to be followed by array decoration.   This provides the useful ability to declare a variable that is an array of the type of some other variable or some table column.

Francesco Tisiot: How to use PostgreSQL® SUBSTRING

Neues vom PostgreSQL Planet - 19. Januar 2024 - 15:00

Need to extract a specific substring out of a text in PostgreSQL®? Read here how!

PostgreSQL SUBSTRING allows you to extract a particular string out of a text column.

The text column can be of:

muhammad ali: Understanding Hash aggregates and Hash Joins in PostgreSQL

Neues vom PostgreSQL Planet - 18. Januar 2024 - 21:54

Discover the reasons behind a planner's selection of Hash aggregate and Hash joins for data processing and understand their workings through this blog.

The post Understanding Hash aggregates and Hash Joins in PostgreSQL appeared first on Stormatics.

Jesse Soyland: One PID to Lock Them All: Finding the Source of the Lock in Postgres

Neues vom PostgreSQL Planet - 18. Januar 2024 - 20:00

On the Customer Success Engineering team at Crunchy Bridge, we run across customers with lock issues on their Postgres database from time to time. Locks can have a cascading effect on queries. If one process is locking a table, then a query can be waiting on the process before it, and the process before that one. Major lock issues can quickly take down an entire production Postgres instance or application.

Francesco Tisiot: 1 billion rows challenge in PostgreSQL and ClickHouse

Neues vom PostgreSQL Planet - 18. Januar 2024 - 16:00

Last week the good old Gunnar Morling launched an interesting challenge about ordering 1 billion rows in Java.

Laurenz Albe: PostgreSQL parallel query problems in JDBC and DBeaver

Neues vom PostgreSQL Planet - 18. Januar 2024 - 10:00


© Laurenz Albe 2024

I recently investigated a surprising behavior of the DBeaver database client in connection with PostgreSQL parallel query, which I’d like to share with you. This might be interesting for everybody who accesses PostgreSQL using the JDBC driver.

oded valin: How to speed up COUNT(DISTINCT)

Neues vom PostgreSQL Planet - 17. Januar 2024 - 14:17

While counting is common in every application, sometimes it is not enough: when we need to display the amount of unique users generating traffic in our website or provide the number of disparate items included in an order we need to apply a distinct count.

Bob Pacheco: Troubleshooting Postgres in Kubernetes

Neues vom PostgreSQL Planet - 17. Januar 2024 - 14:00

In my role as a Solutions Architect at Crunchy Data, I help customers get up and running with Crunchy Postgres for Kubernetes (CPK). Installing and managing a Postgres cluster in Kubernetes has never been easier. However, sometimes things don't go as planned and I’ve noticed a few major areas where Kubernetes installations go awry.

Ahsan Hadi: Logical replication evolution in chronological order & clustering solution built around logical replication

Neues vom PostgreSQL Planet - 17. Januar 2024 - 6:42
A brief history of logical replication in Postgres — and looking ahead at its likely future evolution This blog is divided into two parts. In this section, we walk through how the logical replication feature has evolved over the years, what the recent improvements for Postgres logical replication are, and how the feature will likely change in the future.

Takayuki Tsunakawa: Introducing a new community wiki page "Operations cheat sheet"

Neues vom PostgreSQL Planet - 17. Januar 2024 - 4:51

This is a short announcement of a new PostgreSQL wiki page called Operations cheat sheet . I curated many useful pages (that I find so), mostly from blogs registered in Planet PostgreSQL . Also, I summarized some topics for quick reference. I created this page so that users can learn from rich wisdom PostgreSQL community people and get ready for troubleshooting. For details, please see the Introduction section.

Ricardo Zavaleta: Benchmarking Postgres Vector Search approaches: Pgvector vs Lantern

Neues vom PostgreSQL Planet - 17. Januar 2024 - 1:00

Vector search in Postgres is a space that has seen very active development in the last few months. While Pgvector is known to most people, a few weeks ago we came across Lantern, which also builds a Postgres-based vector database. So, we thought about benchmarking both to compare the two approaches. In this post, we'll cover:

Luca Ferrari: Installing PL/Java on PostgreSQL 16 and Rocky Linux

Neues vom PostgreSQL Planet - 17. Januar 2024 - 1:00

A short recap on some issues when dealing with PL/Java and Rocky Linux.

Installing PL/Java on PostgreSQL 16 and Rocky Linux

It has been a while since I last used PL/Java, and that’s mostly due to the fact that I (luckily) use much more Perl (and hence, PL/Perl) in my everyday activity than Java.

Hans-Juergen Schoenig: Optimizing PostgreSQL functions with preloaded libraries

Neues vom PostgreSQL Planet - 16. Januar 2024 - 16:26

In PostgreSQL, functions and procedures can be written in many different programming languages including but not limited to PL/pgSQL, PL/Perl, PL/Python and a lot more. This flexibility gives the end user the choice to write code in languages of their choice. However, this flexibility has some implications which are often forgotten. Loading libraries early is one of them.

Tristen Raab: JSON in PostgreSQL: Revolutionizing Data Flexibility in Your Database

Neues vom PostgreSQL Planet - 15. Januar 2024 - 22:21
Introduction

In this blog, we’ll go over PostgreSQL’s implementation and handling of JSON objects. Having some experience with Linux, Postgres, and JSON is necessary as we’ll not only be going over these new features but also how to implement them. This blog was written using PostgreSQL 16 (Development Version) running on Ubuntu 23.04. First I’ll go over some background on JSON as a short refresher, then move on to how we use JSON in Postgres, followed by what helpful functions we can use to interact with JSON objects.

Seiten