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: | Whole Thread | Raw Message | 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
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???? |