Sammlung von Newsfeeds
Umair Shahid: Improving PostgreSQL Performance with Partitioning
My recommended methodology for performance improvement of PostgreSQL starts with query optimization. The second step is architectural improvements, part of which is the partitioning of large tables.
Partitioning in PostgreSQL is one of those advanced features that can be a powerful performance booster. If your PostgreSQL tables are becoming very large and sluggish, partitioning might be the cure.
The Big Table Problem
gabrielle roth: LinuxFest Northwest 2025 PostgreSQL Booth Report
Noémi Ványi: pgroll 0.12.0 update
cary huang: Extending PostgreSQL with Java: Overcoming Integration Challenges
Bridging Java and C combines the strengths of both languages. A C application may rely on Java for modern libraries, cloud APIs, or UI and web capabilities, while a Java app might need C for low-level system access or performance-critical tasks. Sometimes, there’s simply no alternative—certain features only exist in one language. While modern languages like C++ and Go offer both high- and low-level control, many systems aren’t written in them.
Lukas Fittl: Waiting for Postgres 18: Accelerating Disk Reads with Asynchronous I/O
Ahsan Hadi: Unleashing the Power of PostgreSQL with pgEdge Distributed Multi-Master Replication and Postgres Platform - Part 2
In this blog, we're continuing to explore the power of multi-master replication (MMR) with the pgEdge distributed Postgres platform and its open source extension, Spock. In the first Part 1 of this blog topic, we discussed different replication methods and deployment models for PostgreSQL replication.
Ahsan Hadi: Unleashing the Power of PostgreSQL with pgEdge Distributed Multi-Master Replication and Postgres Platform - Part 1
Before we delve into the main subject of this blog, it is essential to understand the benefits of PostgreSQL replication, and the difference between single-master replication (SMR) and multi-master replication (MMR). In every modern business application, the database is becoming a critical part of the architecture and the demand for making the database performant and highly available is growing tremendously.
Paolo Melchiorre: Upgrade PostgreSQL from 16 to 17 on Ubuntu 25.04
Howto guide for upgrading PostgreSQL from version 16 to 17 on Ubuntu, after its upgrade from version 24.10 to 25.04 (Plucky Puffin).
Hans-Juergen Schoenig: CREATE INDEX: Data types matter
In the PostgreSQL world, as well as in order database systems, data types play a crucial role in ensuring optimal performance, efficiency, as well as semantics. Moreover, some data types are inherently easier and faster to index than others. Many people are not aware of the fact that indexes indeed make a difference, so let us take a look and see how long it takes to index the very same data using different
types.
Ian Barwick: PgPedia Week, 2025-05-04
The PostgreSQL release is slowly taking shape, with the first draft of release notes now available. Corrections and additions can be sent via the pgsql-hackers thread " PG 18 release notes draft committed ".
Grant Fritchey: AI in the DBeaver Query Editor
You know I had to do it as soon as I found it was possible. Yes, I installed and enabled AI in the DBeaver Query Editor so I can use AI with my PostgreSQL database work. Let’s face it. It was inevitable. However, the setup isn’t intuitive. Setting Up in DBeaver I’m going to assume […]
The post AI in the DBeaver Query Editor appeared first on Grant Fritchey.
Hubert 'depesz' Lubaczewski: Waiting for PostgreSQL 18 – Add function to get memory context stats for processes
Andreas Scherbaum: Checklist for Meetup Attendees
Andreas Scherbaum: Checklist for Meetup Organizers
Andreas Scherbaum: Checklist for Meetup Speakers
Shayon Mukherjee: Another look into PostgreSQL CTE materialization and non-idempotent subqueries
Sergey Solovev: How to handle files?
Greetings!
Fault tolerance is a very important aspect of every non-startup application.
It can be described as a definition:
Fault tolerance is the ability of a system to maintain proper operation despite failures or faults in one or more of its components.
But this gives only slight overview - fault tolerance concerns many areas especially when we are talking about software engineering:
Bruce Momjian: Postgres 18 Release Notes
I have just completed the first draft of the Postgres 18 release notes. It includes a little developer community feedback but still needs more XML markup and links.