As a quick test of Mirror’s write performance, we ran a pipeline of each size backfilling Ethereum blocks data (~18.5M rows as of October 23, 2023) with an unmodified schema.
This test was performed on a 720 GiB RAM, 180 vCPU ClickHouse Cloud instance to ensure that non-pipeline factors (eg. disk IO, available memory, CPU cores) do not act as a bottleneck.
Each test was run on a completely clean instance (ie. no existing tables) with no other queries or commands running on the database.
|Pipeline size||Peak (rows/m)||Time to backfill|