Re: PostgreSQL 12 VS PostgreSQL 15

Oops. Should have put my glasses on :-)
Are all other settings the same?

On Mon, 17 Jul 2023 at 18:13, srinivas oguri <srinivasoguri7(at)gmail(dot)com>
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(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
>>
> --
Bert Desmet
0477/305361