Sammlung von Newsfeeds

Today, I’m very proud and honored to host for the second time the great monthly PGSQL Phriday event! It’s sometimes difficult to find a great topic and I like the kind of topics where there is no consensus. This one is a little particular: in my humble opinion, the database community has a consensus, it’s that developers don’t agree.` Let’s organize a debate between database people and developers! I hope this will lead to great conversation and better understanding between those two groups!

Me and Enrico talk about out latest book on Doug’s Tech Bit show!

Learn PostgreSQL - second edition - Tech Bits

I’m really glad that me and Enrico were hosted on the great Doug’s Tech Bits show. You can see the podcast on YouTube:

I would like to thank Doug Ortiz for his excellent work.

Introduction

When you send a query to PostgreSQL, it will undergo several processing stages in the backend. Each of these stages has different responsibilities to ensure that you receive correct responses in shortest amount of time possible. Yes, they can be quite large and complex to fully understand but I believe it is important for PostgreSQL developer like you to at least understand their roles in handling a query. In this blog, I will give an overview of each query processing stage, their roles and significance in PostgreSQL architecture.

Google Summer of Code is back for 2024! Please review this announcement blog post.

And please make yourself familiar with the GSoC 2024 timeline!

A commit caught my attention during my technical watch:

At Tembo (like every aaS provider), we wanted to have a customer data warehouse to track and understand customer usage and behavior. We wanted to quickly answer questions like "How many Postgres instances have we deployed?", "Who is our most active customer?" and "How many signups do we have by time?". In order to do this, we needed to bring data from several sources into a single location and keep it up-to-date so we could build the dashboards.

Unraveling the Mystery: Why PostgreSQL Costs You Nothing  Each time I mention that PostgreSQL comes with zero licensing fees, I’m met with skeptical looks and a barrage of “Really? But how much does the license actually cost?”. It has happened enough times that I decided to write a blog explaining this, keeping in mind especially […]

I was recently conducting a training session on the query planner, looking at the bits of information, and we discussed the “Rows Removed by Filter.”

I was seeing a value of one less than the total row count, which made sense, since the query had a LIMIT of 1.

However, as I changed the query parameter, the value from “Rows Removed by Filter” returned different values. I realized I didn’t fully understand the behavior, so I wanted to take that opportunity to strengthen my understanding of what was happening.

PostgreSQL is an open-source relational database management system. A large number of PostgreSQL functions are available as standard, and documentation for these can be found in the official documentation. However, it is possible to create your own extensions for specific needs. You can check PGXN, the PostgreSQL Extension network. This is a central distribution system for open-source PostgreSQL extensions. In this blog post I’m going to talk about the different PostgreSQL extensions developed by Adjust.

The PostgreSQL Project is present with a booth at FOSDEM ever since 2007. And ever since 2008 we organize a Devroom, starting 2013 we also have our own PGDay on the Friday before FOSDEM. This year it’s the 10th FOSDEM PGDay, skipping 2021 and 2022 for obvious reasons.

This blog post provides useful information for visitors of the PGDay, the booth and the PostgreSQL Devroom at FOSDEM.

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.

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

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.

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.

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:

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.

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.

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

© 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.