Step 1: CREATE Postgres and Snowflake Peers
Step 2: Create and populate tables on the Postgres PEER
Below script helps creates and populatepgbench_history
with dummy data on your PostgreSQL peer.
Step 3: Create pgbench_history table on the destination (snowflake) PEER
Step 4: Kick off MIRROR with 8 threads and 50000 rows per partition
Step 5: Monitor the MIRROR
You can connect tolocalhost:8085
to gain full visibility into the different jobs and steps that PeerDB performs under the hood to manage the MIRROR.