Benchmark - only with string data
How to run
See the README.md in the parent directory.
Environment
Here is a benchmark result on the following environment:
- OS: Debian GNU/Linux sid
- CPU: AMD Ryzen 9 3900X 12-Core Processor
- Memory: 64GiB
- PostgreSQL: 17 (not released yet) 5d8aa8bcedae7376bd97e79052d606db4e4f8dd4
- Apache Arrow: 15.0.0-SNAPSHOT e62ec62e40b04b0bfce76d58369845d3aa96a419
- Apache Arrow Flight SQL PostgreSQL adapter: 0.2.0 (not released yet) 14df9b5fe61eda2d71bdfbf67c61a227741f616c
Results
SELECT
100K records:
| Apache Arrow Flight SQL | SELECT | COPY |
|---|---|---|
| 0.040 | 0.017 | 0.016 |
1M records:
| Apache Arrow Flight SQL | SELECT | COPY |
|---|---|---|
| 0.364 | 0.162 | 0.152 |
10M records:
| Apache Arrow Flight SQL | SELECT | COPY |
|---|---|---|
| 2.053 | 1.706 | 1.603 |
INSERT
100K records:
| Apache Arrow Flight SQL | INSERT | COPY |
|---|---|---|
| 0.661 | 0.622 | 0.265 |
1M records:
| Apache Arrow Flight SQL | INSERT | COPY |
|---|---|---|
| 7.028 | 5.956 | 2.915 |
10M records:
| Apache Arrow Flight SQL | INSERT | COPY |
|---|---|---|
| 97.898 | 86.678 | 50.889 |