Features
Feature matrix
WAL or Change Data Capture (CDC) Based Replication
Below table shows supported features and features we are working on for WAL or CDC Based replication from Postgres to different targets. ā meansupported. š ļø means Work in Progress and Coming Soon!.
| Feature | Snowflake | BigQuery | Postgres | S3 | GCS | Azure Event Hubs |
|---|---|---|---|---|---|---|
| Initial Snapshot - Parallelizable | ā | ā | ā | ā | ā | š ļø |
| Incremental Sync (CDC) | ā | ā | ā | ā | ā | ā |
| DML Support - INSERT, UPDATE and DELETE | ā | ā | ā | ā | ā | ā |
| Schema Changes | ā | ā | ā | ā | ā | ā |
| Soft Delete | ā | š ļø | š ļø | š ļø | š ļø | š ļø |
| Partitioned Tables | ā | ā | ā | ā | ā | ā |
| Pausing Mirrors | ā | ā | ā | ā | ā | ā |
| Advanced Types - Arrays, JSONB, HSTORE, Geospatial etc. | ā | ā | ā | ā | ā | ā |
| Advanced Monitoring - Lag, Throughput, Postgres Wait Events etc | ā | ā | ā | ā | ā | ā |
| Resync Mirrors | ā | š ļø | š ļø | š ļø | š ļø | š ļø |
| Column Exclusion | š ļø | š ļø | š ļø | š ļø | š ļø | š ļø |
| PeerDB Watchdog - Alerting based on important metrics such as slot size (lag) | š ļø | š ļø | š ļø | š ļø | š ļø | š ļø |
| PeerDB AutoAdapt - Based on activity the on source auto adapt load/pressure | š ļø | š ļø | š ļø | š ļø | š ļø | š ļø |
Query Based or Watermark Based Replication
Below table shows supported features and features we are working on for Query Based or Watermark Based Replication from Postgres to different targets. ā meansupported. š ļø means Work in Progress and Coming Soon!.
| Feature | Snowflake | BigQuery | Postgres | S3 | GCS |
|---|---|---|---|---|---|
| Initial Snapshot | ā | ā | ā | ā | ā |
| Incremental Sync Based on Watermark | ā | ā | ā | ā | ā |
| DML Support - INSERT, UPDATE (if updated_at & primary key are present) | ā | ā | ā | ā | ā |
| Schema Changes - ADD COLUMN | ā | š ļø | š ļø | š ļø | š ļø |
| Resync Mirrors | ā | š ļø | š ļø | š ļø | š ļø |
| Pausing Mirrors | ā | ā | ā | ā | ā |
| Partitioned Tables | ā | ā | ā | ā | ā |
| Advanced Types - Arrays, JSONB, HSTORE, Geospatial etc. | ā | ā | ā | ā | ā |
| Advanced Monitoring - Throughput, Postgres Wait Events etc | ā | ā | ā | ā | ā |
| Column Exclusion | ā | ā | ā | ā | ā |