Peter Smith
PSDE at Fujitsu Australia
About
Peter is a PostgreSQL contributor and member of Fujitsu's Open Source Software team, specialising in logical replication development. He actively reviews enhancements to PostgreSQL's replication capabilities. Peter also writes technical blogs sharing insights on PostgreSQL development and internals.
Peter Smith has presented the following presentations
- Selective table publishing - Choose exactly which tables to replicate
- Row filtering - Repl...
New Publication Syntax and Sequence Synchronization in PostgreSQL 19 and Beyond
at
PG Down Under 2026
.
presented by Peter Smith and Ajin Cherian
This talk will be co-presented by Peter Smith and Ajin Cherian.
PostgreSQL 19 brings significant enhancements to logical replication, giving administrators far greater control over what gets replicated and how. In this talk, two Fujitsu contributors who worked directly on these features cover complementary aspects of the same story.
Peter Smith opens with the new publication syntax. Post...
more Essentials
Tailoring CREATE PUBLICATION command for Targeted Data Replication
at
PG Down Under 2025
(a complete syntax guide)
presented by Peter Smith
PostgreSQL's CREATE PUBLICATION command now does more than just copy tables. This presentation explores how modern PostgreSQL enables fine-grained control over exactly what data gets replicated.
We'll examine the command's evolution across PostgreSQL versions, showcasing capabilities including: