Neues vom PostgreSQL Planet

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

Colin Copeland: Avoiding Timezone Traps: Correctly Extracting Date/Time Subfields in Django with PostgreSQL

16. Juni 2025 - 21:00

Working with timezones can sometimes lead to confusing results, especially when combining Django's ORM, raw SQL for performance (like in PostgreSQL materialized views), and specific timezone requirements. I recently had an issue while aggregating traffic stop data by year, where all yearly calculations needed to reflect the 'America/New_York' (EST/EDT) timezone, even though our original data contained timestamp with time zone fields.

Andreas 'ads' Scherbaum: Nisha Moond

16. Juni 2025 - 16:00
PostgreSQL Person of the Week Interview with Nisha Moond: Hi! I’m Nisha Moond, based in Bangalore, India - the tech hub. I have over 8+ years of experience in databases. I started my journey tweaking Oracle’s query optimizer and now contribute to the PostgreSQL OSS team at Fujitsu.

Ian Barwick: PgPedia Week, 2025-06-15

16. Juni 2025 - 12:25
PostgreSQL links Blogs, podcasts, newsletters etc. Scaling Postgres 370 - New Scale Out Options (2025-06-15) Postgres Weekly Issue 603 (2025-06-12) Announcements PostgreSQL JDBC 42.7.7 Security update for CVE-2025-49146 (2025-06-13) powa-archivist 5.0.3 is out! (2025-06-11) pg_dumpbinary v2.20 released (2025-06-11) pgtt v4.3 released (2025-06-09) Pgpool-II 4.6.2 released.

Stefanie Janine: Handling BLOBs In PostgreSQL Part 2

16. Juni 2025 - 0:00
BLOBs In PostgreSQL Previous Blog Post

I have already published a blog post about PostgreSQL blobs.

But due to someone posting to get help about another implementation on the PostgreSQL Chat Telegram group about a very unusual method to store blobs, I thought, that should now also be covered.

I did not cover that method, because it is one of the worst ideas to handle blobs inside PostgreSQL.

Boriss Mejias: Contributions for the week of 2025-06-02 (Week 23)

12. Juni 2025 - 13:12

PG Day France 2025 took place on June 3 and 4 in Mons, Belgium, organized by Leila Bakkali, Matt Cornillon, Stefan Fercot, Flavio Gurgel, Anthony Nowocien, and Julien Riou, with the help of Jean-Paul Argud

Radim Marek: First steps with Logical Replication in PostgreSQL

11. Juni 2025 - 2:00

Most applications start with a single PostgreSQL database, but over time, the need to scale out, distribute the load, or integrate naturally arises. PostgreSQL's logical replication is one of the features that meets these demands by streaming row-level changes from one PostgreSQL instance to another, all using a publish-subscribe model. Logical replication is more than an advanced feature; it provides a flexible framework you can build on to further distribute and integrate PostgreSQL within your architecture.

Umair Shahid: Checklist: Is Your PostgreSQL Deployment Production-Grade?

10. Juni 2025 - 16:00

One of the things I admire most about PostgreSQL is its ease of getting started.

I have seen many developers and teams pick it up, launch something quickly, and build real value without needing a DBA or complex tooling. That simplicity is part of what makes PostgreSQL so widely adopted.

However, over time, as the application grows and traffic increases, new challenges emerge. Queries slow down, disk usage balloons, or a minor issue leads to unexpected downtime.

Ian Barwick: PgPedia Week, 2025-06-08

10. Juni 2025 - 12:11
PostgreSQL 18 changes this week

Of note:

new GUC log_lock_failure renamed to log_lock_failures commit e5a3c9d9 (" postgres_fdw: Inherit the local transaction's access/deferrable modes. ") was reverted PostgreSQL 18 articles What's New in PostgreSQL 18 - a DBA's Perspective (2025-05-23) - Tianzhou

more...

Hans-Juergen Schoenig: Using regular expressions and arrays in PostgreSQL

10. Juni 2025 - 10:00

Regular expressions and PostgreSQL have been a great team for many many years. The same is true for PostgreSQL arrays, which have been around for a long time as well. However, what people rarely do is combine those two technologies into something more powerful that can be used for various purposes.

Stefanie Janine: pgsql_tweaks 0.11.3 Released

10. Juni 2025 - 0:00
pgsql_tweaks is a bundle of functions and views for PostgreSQL

The source code is available on GitLab, a mirror is hosted on GitHub.
One could install the whole package, or just copy what is needed from the source code.

The extension is also available on PGXN.

Andreas 'ads' Scherbaum: Teresa Lopes

9. Juni 2025 - 16:00
PostgreSQL Person of the Week Interview with Teresa Lopes: I am Teresa Lopes, born in Lisbon, Portugal. While living in Portugal, I always divided my time between Lisbon (house/school/work) and Sertã, Castelo Branco (weekends/holidays). At the end of 2023, I decided to move to Berlin and more recently relocated to Amsterdam (got to love the EU 💙💛).

Magnus Hagander: PGConf.EU 2025 - Call for Presentations

9. Juni 2025 - 15:04

The Call for Presentations for PostgreSQL Conference Europe that will take place in Riga, Latvia from October 21 to 24 is now open.

Key dates
  • Submission deadline: 30 June (at midnight, local time Riga, Latvia; GMT+3)
  • Speakers notified: before 1 August
  • Conference: 21-24 October

To submit your proposals and for more information see our website. Speakers can submit up to three (3) proposed talks each.

Andrew Atkinson: CORE Database Schema Design: Constraint-driven, Optimized, Responsive, and Efficient

9. Juni 2025 - 2:00
Introduction

In this post, we’ll cover some database design principles and package them up into a catchy mnemonic acronym.

Software engineering is loaded with acronyms like this. For example, SOLID principles describe 5 principles, Single responsibility, Open-closed, Liskov substitution, Interface segregation and Dependency inversion, that promote good object-oriented design.

Shane Borden: Understanding High Water Mark Locking Issues in PostgreSQL Vacuums

6. Juni 2025 - 22:49

I recently had a customer that wanted to leverage read replicas to ensure that their read queries were not going to impeded with work being done on the primary instance and also required an SLA of at worst a few seconds. Ultimately they weren’t meeting the SLA and my colleagues and I were asked to look at what was going on.

Henrietta Dombrovskaya: Just announced: PG DATA 2026

6. Juni 2025 - 15:21

Chicago is better in summer! Our inaugural event, PG DATA 2026, will kick off 363 days from today, and we want you to be a part of it!

PG DATA’s mission is to encourage the growth of the PostgreSQL community in the Midwest through learning and networking opportunities, to foster collaboration with the developers’ community and academia, and to bring the best global Postgres speakers to our local community.

Ashutosh Bapat: Avoiding disk spills due to PostgreSQL's logical replication

6. Juni 2025 - 11:40

Logical replication is a versatile feature offered in PostgreSQL. I have discussed the the theoretical background of this feature in detail in my POSETTE talk. At the end of the talk, I emphasize the need for monitoring logical replication setup. If you are using logical replication and have setup monitoring you will be familiar with pg_stat_replication_slots.

Gabriele Bartolini: CNPG Recipe 18 - Getting Started with pgvector on Kubernetes Using CloudNativePG

5. Juni 2025 - 22:42

Learn how to set up a PostgreSQL cluster with the pgvector extension on Kubernetes using CloudNativePG—all in a fully declarative way. This article walks you through the process in just a few minutes, from cluster creation to extension installation.

Tomas Vondra: Benchmarking is hard, sometimes ...

5. Juni 2025 - 12:00

I do a fair number of benchmarks, not only to validate patches, but also to find interesting (suspicious) stuff to improve. It’s an important part of my development workflow. And it’s fun ;-) But we’re dealing with complex systems (hardware, OS, DB, application), and that brings challenges. Every now and then I run into something that I don’t quite understand.

Michael Christofides: Approximate the p99 of a query with pg_stat_statements

4. Juni 2025 - 17:58

Cover photo by Luca Upper

I recently saw a feature request for pg_stat_statements to be able to track percentile performance of queries, for example the p95 (95th percentile) or p99 (99th percentile).

Claire Giordano: Ultimate Guide to POSETTE: An Event for Postgres, 2025 edition

4. Juni 2025 - 17:26

POSETTE: An Event for Postgres 2025 is back for its 4th year—free, virtual, and packed with deep expertise. No travel needed, just your laptop, internet, and curiosity.

This year’s 45 speakers are smart, capable Postgres practitioners—core contributors, performance experts, application developers, Azure engineers, extension maintainers—and their talks are as interesting as they are useful.

Seiten