ingestr benchmark results
Duration vs. rows
Median time per tool across data sizes — log duration scale, lower is faster.
1K rows
Postgres → DuckDB
DuckDB → DuckDB
DuckDB → Postgres
MySQL → Postgres
MongoDB → Postgres
MongoDB → DuckDB
DuckDB → Snowflake
Postgres → SQL Server
MySQL → SQL Server
MongoDB → SQL Server
DuckDB → SQL Server
10K rows
Postgres → Postgres
Postgres → DuckDB
DuckDB → DuckDB
DuckDB → Postgres
MySQL → Postgres
MongoDB → Postgres
MongoDB → DuckDB
Postgres → SQL Server
MySQL → SQL Server
MongoDB → SQL Server
DuckDB → SQL Server
100K rows
Postgres → Postgres
Postgres → DuckDB
DuckDB → DuckDB
DuckDB → Postgres
MySQL → Postgres
MongoDB → Postgres
MongoDB → DuckDB
Postgres → Snowflake
MySQL → Snowflake
MongoDB → Snowflake
DuckDB → Snowflake
Postgres → SQL Server
MySQL → SQL Server
MongoDB → SQL Server
DuckDB → SQL Server
1M rows
Postgres → Postgres
Postgres → DuckDB
DuckDB → DuckDB
DuckDB → Postgres
MySQL → Postgres
MongoDB → Postgres
MongoDB → DuckDB
Postgres → Snowflake
MySQL → Snowflake
MongoDB → Snowflake
DuckDB → Snowflake
Postgres → SQL Server
MySQL → SQL Server
MongoDB → SQL Server
DuckDB → SQL Server
10M rows
Postgres → Postgres
Postgres → DuckDB
DuckDB → DuckDB
DuckDB → Postgres
MySQL → Postgres
MongoDB → Postgres
MongoDB → DuckDB
Postgres → SQL Server
MySQL → SQL Server
DuckDB → SQL Server
Methodology
Each tool runs the same source-to-destination copy for a fixed number of rows. Times are wall-clock, measured with hyperfine, with a warmup run discarded and the mean of the timed runs reported. The multiplier shows how many times slower a tool is than the fastest one in that chart.
All tools were run on the same machine with identical source data and warehouse targets. Numbers are reproducible from the raw benchmark dumps — see the benchmark code. Runs are refreshed as engines change — the most recent run wins for each source / destination / row-count combination.
Benchmarks were executed on a Hetzner Cloud CCX63 instance (48 dedicated AMD EPYC-Milan vCPUs, 192 GB RAM, NVMe SSD), running Ubuntu 24.04.4 LTS.