credativ® Blog
Here you will find interesting news about industry-specific topics and us.
Categories
Category
15 December 2025
PostgreSQL 18 Asynchronous Disk I/O - Deep Dive Into Implementation
PostgreSQL 17 introduced streaming I/O – grouping multiple page reads into a single system call and using smarter posix_fadvise() hints. That alone gave up to ~30% faster sequential scans in some workloads, but it was still strictly synchronous: each backend process would issue a read and then sit there waiting for the kernel to return […]
05 December 2025
A deeper look at old UUIDv4 vs new UUIDv7 in PostgreSQL 18
In the past there have been many discussions about using UUID as a primary key in PostgreSQL. For some applications, even a BIGINT column does not have sufficient range: it is a signed 8‑byte integer with range −9,223,372,036,854,775,808 to +9,223,372,036,854,775,807. Although these values look big enough, if we think about web services that collect billions […]
10 November 2025
Representing credativ at PostgreSQL Conference Europe 2025
The European PostgreSQL Conference (PGConf.EU) is one of the largest PostgreSQL events worldwide. In this year it was held 21–24 October in Riga, Latvia. Our company, credativ GmbH, was a bronze sponsor of the conference, and I had the privilege to represent credativ with my talk “Database in Distress: Testing and Repairing Different Types of […]
03 November 2025
PostgreSQL 18 enables data‑checksums by default
As I explained in my talk on PostgreSQL Conference Europe 2025, data corruption can be silently present in any PostgreSQL database and will remain undetected until we physically read corrupted data. There can be many reasons why some data blocks in tables or other objects can be damaged. Even modern storage hardware is far from […]
21 October 2025
Sun, Sea, and SQL: Highlights from Postgres Ibiza 2025
Postgres Ibiza 2025 took place on October 15–17, 2025, at the Palacio de Congresos de Ibiza on the beautiful island of Ibiza in the Mediterranean Sea. The conference is organized by the Spanish non‑profit Fundación PostgreSQL and aims to be a “refreshing, open and diverse Postgres conference” in a “truly unique environment.” And sure enough, […]