Re: PostgreSQL 12 VS PostgreSQL 15

[srinivas oguri <srinivasoguri7@xxxxxxxxx>]

Yes all settings are same.

On Mon, Jul 17, 2023, 9:51 PM Bert <biertie@xxxxxxxxx> wrote:

Oops. Should have put my glasses on :-) 

Are all other settings the same?

On Mon, 17 Jul 2023 at 18:13, srinivas oguri <srinivasoguri7@xxxxxxxxx> wrote:

Thanks for responding. 

In 12:

Number of transactions: 863125

TPS : 959.153959

In 15:

Number of transactions: 691414

TPS: 768.337953

Thanks

Srinivas 

On Mon, Jul 17, 2023, 9:10 PM Bert <biertie@xxxxxxxxx> wrote:

not an expert here. 

But it seems you processed almost 20K extra transactions. How is that a slowdown? :)

Bert

On Mon, Jul 17, 2023 at 4:19 PM srinivas oguri <srinivasoguri7@xxxxxxxxx> wrote:

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

--

Bert Desmet
0477/305361

--

Bert Desmet
0477/305361