Postgres: Publication Support Via Partition Root
Partitioned Postgres tables replicate as a single root table using publish_via_partition_root, replacing regex patterns for partition names.
Partitioned tables in Postgres can be tricky to manage. Until now, Artie required users to define a regex pattern to capture all partition names - which worked fine, but made replication fragile and error-prone for complex partitioning strategies.
With Postgres' built-in publish_via_partition_root option, we're making things much simpler. Instead of juggling regex patterns, you can now rely on Postgres to publish changes directly through the root table.
If you're using partitioned tables (for example, events_2025_09, events_default, or any custom partition scheme), Artie can now replicate them as if they were a single root table. No regex, no manual upkeep - just treat your partitioned tables like regular ones and let Artie handle the rest.
Why this matters:
- Less fragile: no need to maintain regex rules across changing partitions
- Simpler setup: treat partitioned tables like any other Postgres table
- Fewer errors: Postgres ensures changes flow through the root, reducing replication pitfalls
- More flexibility: works with custom partitioning schemes, not just time-based ones