PostgreSQL 12 VS PostgreSQL 15

From: srinivas oguri <srinivasoguri7(at)gmail(dot)com>
To: pgsql-admin <pgsql-admin(at)postgresql(dot)org>
Subject: PostgreSQL 12 VS PostgreSQL 15
Date: 2023-07-17 14:18:45
Message-ID: CADfH0ysxyf62HEF6h9Q8SBJggtvSmf3H_Yo+b_+C_bthxmzGMQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hi Experts,

I am doing performance testing on Aurora PostgreSQL version 12, 15 using
pgbench. I see the performance is low in 15 compared to 12.

Below is the hardware configuration:

r6g.large
16 GB of RAM
2 vcpu

Below is the command used to initialize the tables: (I have used the
pgbench of 15 version to generate the partitioned tables as we have more
partitioned tables).

./pgbench --initialize --scale=1000 --partition-method=range
--partitions=30 -h <>.rds.amazonaws.com -U postgres -d postgres

For PostgreSQL 15:

./pgbench --client=16 --time=900
--host=<>.rds.amazonaws.com -U postgres -d postgres
pgbench (15.3)
transaction type: <builtin: TPC-B (sort of)>
scaling factor: 1000
partition method: range
partitions: 30
query mode: simple
number of clients: 16
number of threads: 1
maximum number of tries: 1
duration: 900 s
number of transactions actually processed: 691414
number of failed transactions: 0 (0.000%)
latency average = 20.824 ms
initial connection time = 151.272 ms
*tps = 768.337953 (without initial connection time)*
For PostgreSQL 12:

./pgbench --client=16 --time=900
--host=<>.rds.amazonaws.com -U sa -d postgres
pgbench (15.3, server 12.11)
transaction type: <builtin: TPC-B (sort of)>
scaling factor: 1000
partition method: range
partitions: 30
query mode: simple
number of clients: 16
number of threads: 1
maximum number of tries: 1
duration: 900 s
number of transactions actually processed: 863125
number of failed transactions: 0 (0.000%)
latency average = 16.681 ms
initial connection time = 146.719 ms
*tps = 959.153959 (without initial connection time)*

I did testing multiple times with different connections but still the same.

Thanks
Srinivas

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Bert 2023-07-17 15:40:46 Re: PostgreSQL 12 VS PostgreSQL 15
Previous Message Chris Hoover 2023-07-17 00:30:59 Help with logical replication: pg_replication_slots.active_pid is null????