8000 arrow-flight-sql-postgresql/benchmark/integer at main · apache/arrow-flight-sql-postgresql · GitHub
[go: up one dir, main page]
Skip to content

Latest commit

 

History

History

integer

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 integer 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.014 0.015 0.012

1M records:

Apache Arrow Flight SQL SELECT COPY
0.082 0.140 0.112

10M records:

Apache Arrow Flight SQL SELECT COPY
0.691 1.463 1.108

INSERT

Graph

100K records:

Apache Arrow Flight SQL INSERT COPY
0.497 0.310 0.068

1M records:

Apache Arrow Flight SQL INSERT COPY
7.013 5.410 0.637

10M records:

Apache Arrow Flight SQL INSERT COPY
55.064 37.522 6.720
0