8000 arrow-flight-sql-postgresql/benchmark/string at main · apache/arrow-flight-sql-postgresql · GitHub < 8000 meta name="release" content="e34ac8be2ef9ee01763dc85d77610e0a7eaed787">
[go: up one dir, main page]
Skip to content

Latest commit

 

History

History

string

Folders and files

NameName
Last commit message
Last commit date

parent directory

..
README.md
README.md
 
 
insert.csv
insert.csv
 
 
insert.svg
insert.svg
 
 
prepare-sql.sh
prepare-sql.sh
 
 
select.csv
select.csv
 
 
select.svg
select.svg
 
 

README.md

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

Graph

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

Graph

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
0