Neues vom PostgreSQL Planet
semab tariq: Understanding Split-Brain Scenarios in Highly Available PostgreSQL Clusters
High Availability (HA) refers to a system design approach that ensures a service remains accessible even in the event of hardware or software failures. In PostgreSQL, HA is typically implemented through replication, failover mechanisms, and clustering solutions to minimize downtime and ensure data consistency. Hence, HA is very important for your mission-critical applications.
Alexander Korotkov: Bridged Indexes in OrioleDB: architecture, internals & everyday use?
Since version beta10 OrioleDB supports building indexes other than B-tree. Bridged indexes are meant to support these indexes on OrioleDB tables.
David Wheeler: Postgres Extensions: Use PG_MODULE_MAGIC_EXT
A quick note for PostgreSQL extension maintainers: PostgreSQL 18 introduces a new macro: PG_MODULE_MAGIC_EXT. Use it to name and version your modules. Where your module .c file likely has:
PG_MODULE_MAGIC;Or:
#ifdef PG_MODULE_MAGIC PG_MODULE_MAGIC; #endifChange it to something like:
Andrew Atkinson: Tip: Put your Rails app on a SQL Query diet
Much of the time taken processing HTTP requests in web apps is processing SQL queries. To minimize that, we want to avoid unnecessary or duplicate queries, and generally perform as few queries as possible.
Think of the work that needs to happen for every query. The database engine parses it, creates a query execution plan, executes it, and then sends the response to the client.
When the response reaches the client, there’s even more work to do. The response is transformed into application objects in memory.
Brandur Leach: Don't mock the database: Data fixtures are parallel safe, and plenty fast
The API powering our Crunchy Bridge product is written in Go, a language that provides a good compromise between productivity and speed. We're able to keep good forward momentum on getting new features out the door, while maintaining an expected latency of low double digits of milliseconds for most API endpoints.
Tomas Vondra: Advanced Patch Feedback Session (APFS) at pgconf.dev 2025
The pgconf.dev conference, a revamp of the original PGCon, happened about two weeks ago. It’s the main event for Postgres developers, and one of the things we’re trying is an Advanced Patch Feedback Session (APFS).
We first tried that last year in Vancouver, and then again in Montreal. But I realized many people attending the conference either are not aware of the event at all, or are not sure what it’s about. So let me explain, and share some reflections from this year.
Karen Jex: PostgreSQL Europe Diversity Task Force (Deep Dive and Updates)
I'm sharing the slides and transcript from my talk about the PostgreSQL Europe Diversity Task Force at PostgreSQL Development Conference 2025.
It's an extended version of the 5 minute lightning talk that I gave at FOSDEM PGDay earlier this year, with some updates on what we've achieved.
If you want a shorter read, feel free to check out the annotated slides from the lightning talk instead!
Andrew Farries: pgroll 0.13.0: Start using pgroll on existing databases with the new baseline feature
Henrietta Dombrovskaya: Prairie Postgres Developers Summit
Even before the Community Summit in Montreal, I wanted to organize a Developers Summit at one of our meetups. My inspiration came from the Open spaces at DevOps Day Chicago. I saw how productive the smaller group discussions could be, and wanted to try to discuss different aspects of interactions.
We finally made it happen on May 22! In the meetup announcement, I asked those signing up to vote for topics we wanted to suggest and name additional topics. Then, when a meetup started, we re-voted the topics, and same as in Montreal, the outcome was different :).
Andreas 'ads' Scherbaum: Dirk Krautschick
Jimmy Angelakos: Contributions for the week of 2025-05-19 (Weeks 20/21 overview)
-
Postgres Extensions Day took place May 12 in Montreal, Canada, organized by Chris Travers, and Yurii Rashkovskii, with Andrei Lepikhov, Michel Pelletier, and Gwen Shapira additionally on the Talk Selection Committee.
Ian Barwick: PgPedia Week, 2025-05-25
Sadly two features were reverted this week:
planner optimization "Partitions pruned by initial pruning are no longer locked" (commit 525392d5 , reverted in commit 1722d5eb ) function pg_get_process_memory_contexts() (commit 042a6629 , reverted in commit fb844b9f ) PostgreSQL 18 articles UUIDv7 Comes to PostgreSQL 18 (2025-05-09) - Gwen ShapiraÁlvaro Hernández: How to Build Postgres with Zig: A Drop-In GCC/Clang Alternative
In case you are not familiar with it, Zig is a programming language. Among other characteristics, Zig prides itself on being a low-level / systems programming language with great interoperability with C and C++.
Andrew Atkinson: Big Problems From Big IN lists with Ruby on Rails and PostgreSQL
If you’ve created web apps with relational databases and ORMs like Active Record (part of Ruby on Rails), you’ve probably experienced database performance problems after a certain size of data and query volume.
In this post, we’re going to look at a specific type of problematic query pattern that’s somewhat common.
Jeremy Schneider: Collation Torture Test versus Debian
Collation torture test results are finally finished and uploaded for Debian.
https://github.com/ardentperf/glibc-unicode-sorting
The test did not pick up any changes in en_US sort order for either Bullseye or Bookworm
Buster has glibc 2.28 so it shows lots of changes – as expected.
Henrietta Dombrovskaya: Community Summit at PGConf.dev
Last week, I presented at the PGConf.dev for the first time and participated in a community summit for the first time. The idea was pitched by Teresa Giacomini, and that’s how this event was described in the program:
cary huang: Postgres Extensions Day 2025 Kicks Off with a Successful Debut in Montréal
PostgreSQL Extension Day 2025 made its successful debut on May 12, 2025, just one day before the start of pgconf.dev 2025. This focused one-day event brought together the community around a single theme: the PostgreSQL extension ecosystem. From innovative ideas and development insights to discussions on safer extension building and delivery, the day was all about “everything extensions.”
David Wheeler: Adventures in Extension Packaging
I gave a presentation at PGConf.dev last week, Adventures in Extension Packaging.
semab tariq: Best Practices for TimescaleDB Massive Delete Operations
Welcome to the second part of our TimescaleDB best practices series! In the first part, we explored how to perform massive backfill operations efficiently, sharing techniques to optimize performance and avoid common pitfalls. If you haven’t had a chance to read the first part yet, you can check it out using this link
In today’s blog, we will discuss another crucial aspect of time-series data management: massive delete operations.
Hubert 'depesz' Lubaczewski: pg_dump speed across versions
Seiten
- 1
- 2
- 3
- 4
- 5
- 6
- 7
- 8
- 9
- …
- nächste Seite ›
- letzte Seite »