# postgresql 18

Published articles for postgresql 18.

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 18 Upgrades for AI-Era Workloads and Operations

DevFeed: [PostgreSQL 18 Upgrades for AI-Era Workloads and Operations](<https://devfeed.tech/articles/postgresql-18-upgrades-for-ai-era-workloads-and-operations-19117.md>)

Original publisher: [Read original article](<https://severalnines.com/blog/postgresql-18-upgrades-for-ai-era-workloads-and-operations/>)

Author: Sebastian Insausti

Published: 2026-03-20T08:00:00Z

Content type: article

Language: en

Sources: [SeveralNines](<https://devfeed.tech/sources/severalnines.md>)

Topics: [PostgreSQL](<https://devfeed.tech/topics/postgresql.md>), [Software as a service](<https://devfeed.tech/topics/saas.md>), [Transactions](<https://devfeed.tech/topics/transactions.md>)

Tags: [ai](<https://devfeed.tech/tags/ai.md>), [aio](<https://devfeed.tech/tags/aio.md>), [async](<https://devfeed.tech/tags/async.md>), [latency](<https://devfeed.tech/tags/latency.md>), [maintenance](<https://devfeed.tech/tags/maintenance.md>), [performance](<https://devfeed.tech/tags/performance.md>), [postgresql](<https://devfeed.tech/tags/postgresql.md>), [postgresql-18](<https://devfeed.tech/tags/postgresql-18.md>), [replication](<https://devfeed.tech/tags/replication.md>), [storage](<https://devfeed.tech/tags/storage.md>), [upgrades](<https://devfeed.tech/tags/upgrades.md>), [upgrades-patches](<https://devfeed.tech/tags/upgrades-patches.md>)

### AI overview

This article examines PostgreSQL 18 upgrades for transaction, analytics, SaaS, event-data, and vector-search workloads. It focuses on operational improvements including asynchronous I/O, safer upgrades that retain optimizer statistics, improved multi-column indexes, UUIDv7 support, and logical replication enhancements.

### Source excerpt

Today, we're asking PostgreSQL to do more and more, like handling both transactions and analytics, powering huge SaaS platforms, managing event data, and even dipping into AI-related tasks like vector search. This intense pressure highlights some pain points: slow, unpredictable reads, rigid indexing, complex setups, and risky major upgrades. PostgreSQL 18 directly addresses these real-world [...] The post PostgreSQL 18 Upgrades for AI-Era Workloads and Operations appeared first on Severalnines.