Mon May 20 12:35:01 2024

PostgreSQL Driver Performance Benchmark Report

Overall Results

The charts below show the geometric average of all benchmark results.

Individual Benchmarks

1-pg_type.json x10

Test Setup

N/A

Test Query

select typname, typnamespace, typowner, typlen, typbyval, typcategory, typispreferred, typisdefined, typdelim, typrelid, typelem, typarray from pg_type where typtypmod = $1 and typisdefined = $2

Args: [-1, True]

2-generate_series.json x10

Test Setup

N/A

Test Query

SELECT i FROM generate_series(1, $1) AS i

Args: [1000]

3-large_object.json x10

Test Setup

CREATE TABLE _bytes(b bytea); INSERT INTO _bytes(b) (SELECT repeat('a', 1000)::bytea FROM generate_series(1, 100));

Test Query

SELECT * FROM _bytes

Args: []

6-batch.json x10

Test Setup

CREATE TABLE _test(a int, b int, c int, d text, e real, f int, g text);

Test Query

INSERT INTO _test (a, b, c, d, e, f, g) VALUES ($1, $2, $3, $4, $5, $6, $7);

Args: [{'row': [10, 11, 10, 'TESTTESTTEST', 10.333, 12341234, '123412341234'], 'count': 1000}]

7-oneplusone.json x10

Test Setup

N/A

Test Query

SELECT 1+1

Args: []

Detailed Benchmark Data