Exploring new enhancements and improvements Fujitsu has delivered to
summary
Fujitsu details concrete PostgreSQL contributions: new conflict logging and seven conflict types (plus a proposed update_deleted conflict with dead-tuple retention and a max_conflict_retention_duration to avoid indefinite slots), safer tools like autosubscription skip LSN and PG replication origin advance, and required track_commit_timestamp. Parallel apply is now default for large transactions (PG16→PG18) and halves apply time in one test (1,000,000 inserts from 120s to 60s), with tuning via decoding_work_mem. Planned features include accept table clause for exclusions and a pgreate subscriber tool that speeds logical conversion for tables >500MB.
AI-written summary · about
chapters (9)
- 0:00Introduction to logical replication
- 1:09Conflict management in replication
- 15:25Postgres 18 conflict handling types
- 26:29Future conflict resolution plans
- 30:27Parallel apply for large transactions
- 36:59Table exclusions in Postgres 19
- 39:50Seamless cluster upgrades
- 48:24PGcreate subscriber tool
- 49:48Summary and Q&A
related talks
46mPostgreSQL 16 and beyond
54mBreakout Session
52mA look at the Elephants Trunk - PostgreSQL 15
14mBuilding a better PostgreSQL together
39mLogical Replication handling of large transactions
44mThe journey towards active-active replication in PostgreSQL
43mPostgreSQL 17 and beyond
53mThe journey towards active replication in PostgreSQL