TRENDING

TECHNOLOGY NEWS FROM AROUND THE WORLD

→
2021: PostgreSQL 14 improved data pipelines and observability
PostgreSQL sürüm duyurusuIN-DEPTH NEWS

2021: PostgreSQL 14 improved data pipelines and observability

PostgreSQL 14 introduced client-side pipelining and improvements to data access and monitoring. We examine what those changes mean for correctness and operations.

· Published: ·PostgreSQL sürüm duyurusu
Reading progress0%

The September 2021 release

PostgreSQL 14 was announced on September 30, 2021. The project highlighted complex data types, concurrency, replication and performance, while EDB described contributions and their practical implications. These are technical accounts from the project and a contributing company, not an independent benchmark conducted for this article. The retrospective examines why a database release should be read in relation to workload characteristics and data correctness rather than treated as a universal promise of faster queries.

Where pipelining helps

Pipeline mode in the libpq client allows commands to be sent without waiting for each preceding response. The project explicitly described this as a client capability. Upgrading a server therefore does not automatically convert existing application traffic into pipelined traffic. Our editorial recommendation is to measure network waiting in workloads containing many small operations. Results still need to be matched to commands, and failures require deliberate handling. Sending faster does not remove the obligation to verify outcomes.

Data structures and monitoring

The release added conveniences for JSON access and support for noncontiguous ranges, alongside improvements in operational visibility. Monitoring information can help explain what the system is doing, but available metrics alone do not create an effective alerting policy. We suggest defining the business consequences of delay or missing data before choosing dashboard indicators. That connects a technical feature to an operational decision and avoids confusing a large collection of measurements with a reliable understanding of system health.

Designing an upgrade evaluation

An evaluation could combine typical queries with transaction rollback, interrupted connections and retry scenarios. In a batch import, the team needs to know which operations completed when another operation failed. This is a proposed testing approach, not a reported experiment. Query plans, indexes and data distribution can change results, so a single timing should not become a broad performance claim. Recovery procedures and application compatibility also belong in acceptance criteria whenever a database version is changed.

A lesson beyond the release

The historical lesson is that client behavior and database engine capabilities must be considered together. A new feature can require driver support, connection changes or application work, rather than only a server setting. Present-day version choices require a separate check of current support. For discussion: would you investigate network waiting, query planning or transaction design first when a database feels slow? Useful measurements distinguish these causes while keeping correctness visible throughout the investigation.

Illustrative news photo · Julio Lopez / Unsplash ↗

Sources and verification

Be the first reader ✎ Write a comment

Comments

Reader question: In which practical scenario would this technology be useful?

No comments yet. Be the first to contribute.

Write a comment

Your first and last name will appear publicly alongside your comment.

Sample comments and editor reply

Discussion example — not real reader feedback. Names and conversations in this area are fictional. Likes and replies here are not saved and do not count as real engagement.

Example counters: 9,759 reads · 679 likes — not actual analytics

Ayşe Yılmaz

Reading “2021: PostgreSQL 14 improved data pipelines and observability” raised this question for me: independent tests should precede firm conclusions.

Sample editor reply

Editor note: Forward-looking claims in an announcement are not the same as established performance results. Further evidence may change the assessment.

Fatma Demir

It is important to distinguish what the source verifies from projections about the future.

Mehmet Kaya

The next version's measurements should be compared with the initial announcement.

Sidney Wood

Reading “2021: PostgreSQL 14 improved data pipelines and observability” today, which limitations of that period still matter?

Sample editor reply

The topic year provides the historical context. Applying an archive finding today requires checking the source date and current conditions.