Overview#
What is this?#
Apache Arrow Flight SQL adapter for PostgreSQL is a PostgreSQL extension that adds an Apache Arrow Flight SQL endpoint to PostgreSQL.
Apache Arrow Flight SQL is a protocol to use Apache Arrow format to interact with SQL databases. You can use Apache Arrow Flight SQL instead of the PostgreSQL wire protocol to interact with PostgreSQL by Apache Arrow Flight SQL adapter for PostgreSQL.
Apache Arrow format is designed for fast typed table data exchange. If
you want to get large data by SELECT
or INSERT
/UPDATE
large
data, Apache Arrow Flight SQL will be faster than the PostgreSQL wire
protocol.
Benchmark#
See also a simple benchmark result that just
executes SELECT * FROM integer_only_table
. It shows that Apache
Arrow Flight SQL is faster than the PostgreSQL wire protocol when
result data is large.