Re: PostgreSQL 12 VS PostgreSQL 15

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(at)gmail(dot)com> 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(at)gmail(dot)com>
> 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
>