Sammlung von Newsfeeds

Henrietta Dombrovskaya: Chicago PUG February Meetup recording

Neues vom PostgreSQL Planet - 13. März 2025 - 3:22

Hi Postgres community, apologies for the delay one more time – here is the recording of our February meetup! If you didn’t have a chance to attend in person or virtual, please take a moment to watch! You won’t be disappointed!

Also, one more reminder that our March meetup will take place later in the month than usual: on March 25. That will be the last meetup before PG Day Chicago, and I hope you will be able to attend!

Hubert 'depesz' Lubaczewski: Waiting for PostgreSQL 18 – Allow parallel CREATE INDEX for GIN indexes

Neues vom PostgreSQL Planet - 11. März 2025 - 14:06
On 3rd of March 2025, Tomas Vondra committed patch: Allow parallel CREATE INDEX for GIN indexes   Allow using parallel workers to build a GIN index, similarly to BTREE and BRIN. For large tables this may result in significant speedup when the build is CPU-bound.   The work is divided so that each worker builds … Continue reading "Waiting for PostgreSQL 18 – Allow parallel CREATE INDEX for GIN indexes"

Laurenz Albe: stats_fetch_consistency: caching PostgreSQL monitoring statistics?

Neues vom PostgreSQL Planet - 11. März 2025 - 8:52
© Laurenz Albe 2025

I have worked with PostgreSQL since 2006. Still, I keep learning about new aspects of PostgreSQL regularly. Sometimes it feels like the more I know, the better I see that I have yet a lot to learn. Often, beginners' questions in a training session make me learn something new! Today, my co-worker Pavlo told be about the PostgreSQL parameter stats_fetch_consistency. Probably not a parameter that you want to tune every day, but you never know.

Umair Shahid: When HASH partitioning works better than RANGE

Neues vom PostgreSQL Planet - 11. März 2025 - 8:51

I have always been a fan of RANGE partitioning using a date/time value in PostgreSQL. This isn't always possible, however, and I recently came across a scenario where a table had grown large enough that it had to be partitioned, and the only reasonable key to use was a UUID styled identifier.

The goal of this post is to highlight when and why hashing your data across partitions in PostgreSQL might be a better approach.

Range vs. Hash Partitioning in PostgreSQL

Range Partitioning (A Quick Recap)

Andreas 'ads' Scherbaum: Doug Ortiz

Neues vom PostgreSQL Planet - 10. März 2025 - 15:00
PostgreSQL Person of the Week Interview with Doug Ortiz: Consider myself a Technologist first and foremost that enjoys immersing into new and emerging technologies and trends. As to where I am from, I am originally a New Yorker that has moved around multiple continents and the USA.

Ryan Booz: Introducing pgNow: A free, point-in-time diagnostic tool for PostgreSQL

Neues vom PostgreSQL Planet - 10. März 2025 - 14:09
pgNow is a free, cross-platform desktop tool created by Redgate that helps you identify key performance metrics and configuration optimizations in your running Postgres instance. Available now as a public preview application, it’s designed to help when you’re in a pinch and don’t have the Postgres experience or monitoring solution already in place to help ... Read more

Luca Ferrari: pgenv 1.4.0 is out!

Neues vom PostgreSQL Planet - 10. März 2025 - 1:00

A new version with an interesting improvement in the configuration management.

pgenv 1.4.0 is out!

pgenv 1.4.0 is out with an interesting improvement regarding the configuration management.

Luca Ferrari: OpenDay 2025 by PgTraining

Neues vom PostgreSQL Planet - 10. März 2025 - 1:00

There are still seats available for this entire day dedicated to PostgreSQL!

OpenDay 2025 by PgTraining

PgTraining is organizing a free for all entire day dedicated to PostgreSQL, where people is going to meet by face.

The event, that will be held in the great NOI Techpark in Bolzano (Italy) will be organized in two parts:

Ian Barwick: PgPedia Week, 2025-03-09

Neues vom PostgreSQL Planet - 9. März 2025 - 21:15

CommitFest 52 (2025-03), the final CommitFest in the PostgreSQL 18 development cycle, is underway.

Andrei Lepikhov: Automated Management of Extended Statistics in PostgreSQL

Neues vom PostgreSQL Planet - 9. März 2025 - 16:34

Here, I am describing the results of a Postgres extension I developed out of curiosity. This extension focuses on the automatic management of extended statistics for table columns. The idea originated while I was finishing another "smart" query-driven project aimed at enhancing the quality of Postgres query planning. I realised that Postgres is not yet equipped enough for fully autonomous poor query plan detection and adjustment optimisations. Therefore, it might be beneficial to approach the problem from a different angle and create an autonomous, data-driven helper.

Henrietta Dombrovskaya: SCaLE 22x

Neues vom PostgreSQL Planet - 8. März 2025 - 17:29

I am behind the rest of the Postgres Community members attending SCaLE 22x, who have already posted a lot! In my defense, all the talks were so interesting that I could not skip any, even though I had to beat the Arctic cold of Ballroom G!

In addition to the regular program, Jimmy Angelakos had a live stream before the start of the talks both on Thursday and Friday and here are the links (I am in the first one).

As I said, I loved all the talks, although one or two ended up being not what I thought they will be, but interesting nevertheless).

Avi Vallarapu: Streaming Replication Internals for High Availability in PostgreSQL

Neues vom PostgreSQL Planet - 6. März 2025 - 16:30

High Availability of databases is one of major Enterprise-grade features required by any Organization. It is important that databases are always accessible, minimizing downtime and maintaining business continuity. In the world of databases like PostgreSQL or Oracle or SQL Server, High Availability is achievable with the introduction of a Standby (or Replica), that continuously replicates […]

Cornelia Biacsics: PGDay Austria Returns

Neues vom PostgreSQL Planet - 6. März 2025 - 8:02

PGDay Austria is set to return to the beautiful city of Vienna on September 4th, 2025. And we’re already in the middle of organising the event. As several important deadlines are approaching, I want to share some things you need to know through this blog post. 

Regina Obe: PG 17 new random functions

Neues vom PostgreSQL Planet - 6. März 2025 - 4:45

Have you ever wanted to get a random integer between 1 and 10 and been a little annoyed the slightly cryptic code you had to write in PostgreSQL? PostgreSQL 17 random functions make that simpler. Sometimes it's the small changes that bring the most joy.

Continue reading "PG 17 new random functions"

Andrew Dunstan: Announcing Release 19.1 of the PostgreSQL Buildfarm client

Neues vom PostgreSQL Planet - 5. März 2025 - 15:30

 Hot on the heels of release 19, release 19.1 fixes a bug in release 19 that caused some builds to fail.

Also as a small improvement it now collects the log from the meson test setup, so failures there can be diagnosed.

Elizabeth Garrett Christensen: Validating Data Types from Semi-Structured Data Loads in Postgres with pg_input_is_valid

Neues vom PostgreSQL Planet - 5. März 2025 - 15:30

Working on big data loads and or data type changes can be tricky - especially finding and correcting individual errors across a large data set. Postgres versions, 16, 17, and newer have a new function to help with data validation: pg_input_is_valid .

pg_input_is_valid is a sql function that can be queried that will determine if a given input can be parsed into a specific type like numeric, date, JSON, etc. Here’s a super basic query to ask if ‘123’ is a valid integer.

Michael Christofides: Postgres query plan visualization tools

Neues vom PostgreSQL Planet - 5. März 2025 - 12:19

When you’ve got a slow Postgres query, EXPLAIN and its parameters are incredibly useful for working out why.

However, the information returned can be difficult and time-consuming to interpret, especially for more complex queries. Over the years, people have built quite a few tools for visualizing Postgres query plans. As one of those people, I’m a little incredibly biased, but as a fan of many of the others, I hope to do them justice.

David Wheeler: Extension Ecosystem Summit 2025

Neues vom PostgreSQL Planet - 5. März 2025 - 1:35

I’m happy to announce that some PostgreSQL colleagues and have once again organized the Extension Ecosystem Summit at PGConf.dev in Montréal on May 13.

Andrew Dunstan: Announcing Release 19 of the PostgreSQL Buildfarm Client

Neues vom PostgreSQL Planet - 4. März 2025 - 16:08

Release 19 has two main features:

  • Adjustment to the way we run cross version upgrade testing, to accommodate the recent statistics import feature
  • Adjust to the new SEpgsql test setup

Also included

Hans-Juergen Schoenig: PostgreSQL: To normalize or not to normalize?

Neues vom PostgreSQL Planet - 4. März 2025 - 8:42

The concept of "normalization" is often the first thing people who are new to databases are going to learn. We are talking about one of the fundamental principles in the realm of databases. But what is the use of normalization in the first place? Well, we want to avoid redundancies in the data and make sure that information is stored in a way that helps reduce mistakes and inconsistencies. Ultimately, that is all there is to it: No redundancies, no mistakes, no inconsistencies.

Seiten