Neues vom PostgreSQL Planet

Neues vom PostgreSQL Planet Feed abonnieren
Planet PostgreSQL
Aktualisiert: vor 56 Minuten 21 Sekunden

Pavlo Golub: Contributions for week 42, 2025

21. Oktober 2025 - 15:13

Belgium Meetup: Tuesday, 14 October 2025 - organized by Boriss Mejias & Stefan Fercot

Speakers:

  • Niradj Selvam
  • Stefan Fercot

Pavlo Golub: Contributions for week 41, 2025

21. Oktober 2025 - 15:12

Barcelona PostgreSQL User Group met on Tuesday, Oct 7, organized by Dave Pitts & Lauro Ojeda

Speakers - Dave Pitts - Lauro Ojeda

Ellyne Phneah released two books: * The Social Code: Building a PostgreSQL Community Wired for Belonging * Decode PostgreSQL: Understanding the World's Most Powerful Open-Source Database Without Writing Code

Laurenz Albe: Benefits of a DESCending index

21. Oktober 2025 - 8:00


© Tobi Albe 2025

PostgreSQL can scan B-tree indexes in both directions. That means that there is little need to create a index in descending order (one created with the DESC clause). However, there are some cases where you need a descending index. There are also some corner cases where a descending index performs better than an ascending one. Follow me to explore use cases for the DESC clause!

Gabriele Bartolini: Postgres in Kubernetes: the commands every DBA should know

21. Oktober 2025 - 7:18

For many Postgres DBAs, Kubernetes feels like a new, complex world. But what if your existing skills were the key to unlocking it? This article demystifies cloud-native Postgres by revealing a first handful of kubectl and kubectl cnpg commands that act as your direct translator. I’ll move past the intimidating YAML to focus on the practical, imperative commands you’ll actually use to troubleshoot, inspect, and even perform a production switchover.

Paolo Melchiorre: Install PostgreSQL 18 on Ubuntu 25.10

21. Oktober 2025 - 0:00

How-to guide for installing PostgreSQL version 18 on Ubuntu, after a fresh installation of version 25.10 (Questing Quokka).

Paul Ramsey: PostGIS Performance: pg_stat_statements and Postgres tuning

20. Oktober 2025 - 15:00

In this series, we talk about the many different ways you can speed up PostGIS. Today let’s talk about looking across the queries with pg_stat_statements and some basic tuning.

Showing Postgres query times with pg_stat_statements

A reasonable question to ask, if you are managing a system with variable performance is: “what queries on my system are running slowly?”

Henrietta Dombrovskaya: Check out my new repo: logs_processing

20. Oktober 2025 - 12:18

I finally shared the set of functions that I use to process pgBadger raw output.

There will be more documentation, I promise, but at least the code is there, along with two of many presentations.

Enjoy! https://github.com/hettie-d/logs-processing

Ian Barwick: PgPedia Week, 2025-10-12

20. Oktober 2025 - 8:15
PostgreSQL 19 changes this week support for Eager Aggregation added column stats_reset added to pg_stat_all_tables /  indexes and related views pg_get_sequence_data() : output column page_lsn added ALL SEQUENCES support added to publications planner hooks planner_setup_hook and planner_shutdown_hook added mem_exceeded_count column added to pg_stat_replication_slots

more...

Ibrar Ahmed: Scaling Postgres

20. Oktober 2025 - 6:38

Postgres has earned its reputation as one of the world's most robust and feature-rich open-source databases. But what happens when your application grows beyond what a single database instance can handle? When your user base explodes from thousands to millions, and your data grows from gigabytes to terabytes?This is where Postgres scaling becomes critical. The good news is that Postgres offers multiple pathways to scale, each with its own advantages and use cases.

Tom Kincaid: Part 2: PostgreSQL’s incredible trip to the top with developers

19. Oktober 2025 - 22:33

In August of this year, I published a blog entitled PostgreSQL’s incredible trip to the top with developers which shows how Postgres has become the most used, most loved and most desired database according to the Stack Overflow annual developer survey. In that blog I said, I want to do the series in two parts. After some thought, I have decided to make it a 3 part series. It will break down as follows:

Tom Kincaid: Part 2: Postgres incredible journey to the top with developers.

19. Oktober 2025 - 22:33


In August of this year, I published a blog entitled PostgreSQL’s incredible trip to the top with developers which shows how Postgres has become the most used, most loved and most desired database according to the Stack Overflow annual developer survey. In that blog I said, I want to do the series in two parts. After some thought, I have decided to make it a 3 part series. It will break down as follows:

Seiten