# postgresql 18

PostgreSQL 18 is an open-source relational database release.

This is one page of public article previews, not the complete archive. Follow Next page to continue. Summaries are not the original full articles.

## pgBackRest Compression: How Much CPU Is a Smaller Backup Worth?

DevFeed: [pgBackRest Compression: How Much CPU Is a Smaller Backup Worth?](<https://devfeed.tech/articles/pgbackrest-compression-how-much-cpu-is-a-smaller-backup-worth-35042.md>)

Original publisher: [Read original article](<https://www.percona.com/blog/pgbackrest-compression-how-much-cpu-is-a-smaller-backup-worth/>)

Author: Agustín Gallego

Published: 2026-09-16T21:43:06Z

Content type: comparison

Language: en

Sources: [Blog - Percona](<https://devfeed.tech/sources/blog-percona.md>)

Topics: [Compression](<https://devfeed.tech/topics/compression.md>), [Algorithms](<https://devfeed.tech/topics/algorithms.md>), [PostgreSQL](<https://devfeed.tech/topics/postgresql.md>), [postgresql 18](<https://devfeed.tech/topics/postgresql-18.md>), [backups](<https://devfeed.tech/topics/backups.md>), [Percona](<https://devfeed.tech/topics/percona.md>)

Tags: [algorithms](<https://devfeed.tech/tags/algorithms.md>), [backup](<https://devfeed.tech/tags/backup.md>), [compare](<https://devfeed.tech/tags/compare.md>), [compression](<https://devfeed.tech/tags/compression.md>), [cpu](<https://devfeed.tech/tags/cpu.md>), [percona](<https://devfeed.tech/tags/percona.md>), [postgresql](<https://devfeed.tech/tags/postgresql.md>), [postgresql-18](<https://devfeed.tech/tags/postgresql-18.md>), [uncategorized](<https://devfeed.tech/tags/uncategorized.md>)

### AI overview

This comparison measures pgBackRest compression algorithms and levels on Percona Distribution for PostgreSQL 18.4. It finds that low-level Zstandard offers a favorable balance between CPU use and backup size, with zst(3) near the efficiency curve's shoulder.

### Source excerpt

In this blog post, we'll compare pgBackRest's compression algorithms and levels to find where spending more CPU stops buying a meaningfully smaller backup. The short version of the answer, which we'll build up to with real numbers, is that Zstandard at a low level is the sweet spot, and its default (zst(3)) already sits right ... Continued The post pgBackRest Compression: How Much CPU Is a Smaller Backup Worth? appeared first on Percona.

## pgcopydb v0.18

DevFeed: [pgcopydb v0.18](<https://devfeed.tech/articles/pgcopydb-v0-18-34617.md>)

Original publisher: [Read original article](<https://tapoueh.org/blog/2026/07/pgcopydb-v0.18/>)

Author: Dimitri Fontaine PostgreSQL Major Contributor; Author

Published: 2026-07-01T14:05:56Z

Content type: release

Language: en

Sources: [Dimitri Fontaine](<https://devfeed.tech/sources/dimitri-fontaine.md>)

Topics: [PostgreSQL](<https://devfeed.tech/topics/postgresql.md>), [postgresql 18](<https://devfeed.tech/topics/postgresql-18.md>), [Replication](<https://devfeed.tech/topics/replication.md>), [migration](<https://devfeed.tech/topics/migration.md>), [SQLite](<https://devfeed.tech/topics/sqlite.md>), [reliability](<https://devfeed.tech/topics/reliability.md>), [Open Source](<https://devfeed.tech/topics/open-source.md>)

Tags: [bug-fixes](<https://devfeed.tech/tags/bug-fixes.md>), [builds](<https://devfeed.tech/tags/builds.md>), [migration](<https://devfeed.tech/tags/migration.md>), [open-source](<https://devfeed.tech/tags/open-source.md>), [postgresql](<https://devfeed.tech/tags/postgresql.md>), [postgresql-18](<https://devfeed.tech/tags/postgresql-18.md>), [release](<https://devfeed.tech/tags/release.md>), [reliability](<https://devfeed.tech/tags/reliability.md>), [replication](<https://devfeed.tech/tags/replication.md>), [sqlite](<https://devfeed.tech/tags/sqlite.md>)

### AI overview

A release announcement for pgcopydb v0.18, covering PostgreSQL 16-18 compatibility, a pgoutput-default change-data-capture engine, filtering, Citus-to-Citus migrations, reliability improvements, and 24 bug fixes.

### Source excerpt

Hot off the press: pgcopydb v0.18 is out! It's the biggest release the project has had -- 88 commits since v0.17, which shipped in August 2024. I took a break from my Open Source responsibilities for a while, because I was lacking employer support to make it happen. What is pgcopydb pgcopydb copies a PostgreSQL database to another PostgreSQL server, as fast as possible when physical file copy isn't available. It parallelises the COPY across all tables simultaneously, builds indexes in parallel after data is loaded, and supports Change Data Capture via logical replication for minimal-downtime migrations. It is designed to be restartable: state is tracked in a local SQLite catalog so an interrupted run can resume where it left off. Headline Features of pgcopydb v0.18 v0.18 brings compatibility with PostgreSQL 16, 17, and 18; a pgoutput-default CDC engine with significant reliability and performance improvements; regular-expression-based filtering; Citus-to-Citus migration support; and 24 bug fixes.

## PostgreSQL temporal UPDATE and DELETE by range

DevFeed: [PostgreSQL temporal UPDATE and DELETE by range](<https://devfeed.tech/articles/waiting-for-postgresql-19-add-update-delete-for-portion-of-33685.md>)

Original publisher: [Read original article](<https://www.depesz.com/2026/04/02/waiting-for-postgresql-19-add-update-delete-for-portion-of/>)

Author: depesz

Published: 2026-04-02T10:51:21Z

Content type: tutorial

Language: en

Sources: [select \* from depesz;](<https://devfeed.tech/sources/select-from-depesz.md>)

Topics: [PostgreSQL](<https://devfeed.tech/topics/postgresql.md>), [postgresql 18](<https://devfeed.tech/topics/postgresql-18.md>)

Tags: [delete](<https://devfeed.tech/tags/delete.md>), [period](<https://devfeed.tech/tags/period.md>), [pg19](<https://devfeed.tech/tags/pg19.md>), [postgresql](<https://devfeed.tech/tags/postgresql.md>), [query](<https://devfeed.tech/tags/query.md>), [range](<https://devfeed.tech/tags/range.md>), [temporal](<https://devfeed.tech/tags/temporal.md>), [uncategorized](<https://devfeed.tech/tags/uncategorized.md>), [update](<https://devfeed.tech/tags/update.md>), [version](<https://devfeed.tech/tags/version.md>), [waiting](<https://devfeed.tech/tags/waiting.md>)

### AI overview

This article explains a PostgreSQL patch that extends UPDATE and DELETE for temporal tables, allowing changes or deletions over a specified range or multirange period. The article also notes that the patch was later reverted after discussion.

### Source excerpt

Important update This has been reverted with some discussion. Thanks for ping to mkurz 🙂 On 1st of April 2026, Peter Eisentraut committed patch: Add UPDATE/DELETE FOR PORTION OF This is an extension of the UPDATE and DELETE commands to do a "temporal update/delete" based on a range or multirange column. The user can ... Continue reading "Waiting for PostgreSQL 19 - Add UPDATE/DELETE FOR PORTION OF"