[prev in list] [next in list] [prev in thread] [next in thread]
List: postgresql-admin
Subject: Re: PostgreSQL 12 VS PostgreSQL 15
From: srinivas oguri <srinivasoguri7 () gmail ! com>
Date: 2023-07-17 18:15:32
Message-ID: CADfH0yvFcMZOXkHtYZqAegoHWN+thXO1mAZnNPYM7C+6L-FMDQ () mail ! gmail ! com
[Download RAW message or body]
Yes all settings are same.
On Mon, Jul 17, 2023, 9:51 PM Bert <biertie@gmail.com> 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@gmail.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@gmail.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@gmail.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
>
[Attachment #3 (text/html)]
<div dir="auto">Yes all settings are same.</div><br><div class="gmail_quote"><div \
dir="ltr" class="gmail_attr">On Mon, Jul 17, 2023, 9:51 PM Bert <<a \
href="mailto:biertie@gmail.com">biertie@gmail.com</a>> wrote:<br></div><blockquote \
class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc \
solid;padding-left:1ex"><div dir="auto">Oops. Should have put my glasses on :-) \
</div><div dir="auto">Are all other settings the same?</div><div><br><div \
class="gmail_quote"><div dir="ltr" class="gmail_attr">On Mon, 17 Jul 2023 at 18:13, \
srinivas oguri <<a href="mailto:srinivasoguri7@gmail.com" target="_blank" \
rel="noreferrer">srinivasoguri7@gmail.com</a>> wrote:<br></div><blockquote \
class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc \
solid;padding-left:1ex"><div dir="auto"><div>Thanks for responding. </div><div \
dir="auto"><br></div><div dir="auto">In 12:</div><div dir="auto"><br></div><div \
dir="auto">Number of transactions: 863125</div><div dir="auto">TPS : \
959.153959</div><div dir="auto"><br></div><div dir="auto">In 15:</div><div \
dir="auto"><br></div><div dir="auto">Number of transactions: 691414</div><div \
dir="auto">TPS: 768.337953</div><div dir="auto"><br></div><div \
dir="auto">Thanks</div><div dir="auto"></div></div><div dir="auto"><div \
dir="auto">Srinivas <br><br><div class="gmail_quote" dir="auto"><div dir="ltr" \
class="gmail_attr">On Mon, Jul 17, 2023, 9:10 PM Bert <<a \
href="mailto:biertie@gmail.com" target="_blank" \
rel="noreferrer">biertie@gmail.com</a>> wrote:<br></div><blockquote \
class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc \
solid;padding-left:1ex"><div dir="ltr">not an expert here. <div>But it seems you \
processed almost 20K extra transactions. How is that a slowdown? \
:)</div><div><br></div><div>Bert</div></div><br><div class="gmail_quote"><div \
dir="ltr" class="gmail_attr">On Mon, Jul 17, 2023 at 4:19 PM srinivas oguri <<a \
href="mailto:srinivasoguri7@gmail.com" rel="noreferrer noreferrer" \
target="_blank">srinivasoguri7@gmail.com</a>> wrote:<br></div><blockquote \
class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid \
rgb(204,204,204);padding-left:1ex"><div dir="ltr">Hi \
Experts,<br><div><br></div><div>I am doing performance testing on Aurora PostgreSQL \
version 12, 15 using pgbench. I see the performance is low in 15 compared to \
12.</div><div><br></div><div>Below is the hardware \
configuration:</div><div><br></div><div>r6g.large</div><div>16 GB of RAM</div><div>2 \
vcpu</div><div><br></div><div>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).</div><div><br></div><div><div \
style="color:rgb(0,0,0);font-family:Consolas,"Courier \
New",monospace;font-size:14px;line-height:19px;white-space:pre-wrap"><div>./pgbench \
--initialize --scale=1000 --partition-method=range </div><div>--partitions=30 -h \
<>.<a href="http://rds.amazonaws.com" rel="noreferrer noreferrer" \
target="_blank">rds.amazonaws.com</a> -U postgres -d \
postgres</div><div><br></div><div>For PostgreSQL \
15:<br></div><div><br></div><div><div style="line-height:19px"><div>./pgbench \
--client=16 --time=900 </div><div>--host=<>.<a href="http://rds.amazonaws.com" \
rel="noreferrer noreferrer" target="_blank">rds.amazonaws.com</a> -U postgres -d \
postgres</div></div> </div><div><div style="line-height:19px"><div><span \
style="color:rgb(0,0,255)">pgbench (15.3)</span></div><div><span \
style="color:rgb(128,0,0)">transaction type</span>: <span \
style="color:rgb(128,0,0)"><builtin</span>: <span style="color:rgb(0,0,255)">TPC-B \
(sort of)></span></div><div><span style="color:rgb(128,0,0)">scaling \
factor</span>: <span style="color:rgb(9,134,88)">1000</span></div><div><span \
style="color:rgb(128,0,0)">partition method</span>: <span \
style="color:rgb(0,0,255)">range</span></div><div><span \
style="color:rgb(128,0,0)">partitions</span>: <span \
style="color:rgb(9,134,88)">30</span></div><div><span \
style="color:rgb(128,0,0)">query mode</span>: <span \
style="color:rgb(0,0,255)">simple</span></div><div><span \
style="color:rgb(128,0,0)">number of clients</span>: <span \
style="color:rgb(9,134,88)">16</span></div><div><span \
style="color:rgb(128,0,0)">number of threads</span>: <span \
style="color:rgb(9,134,88)">1</span></div><div><span \
style="color:rgb(128,0,0)">maximum number of tries</span>: <span \
style="color:rgb(9,134,88)">1</span></div><div><span \
style="color:rgb(128,0,0)">duration</span>: <span style="color:rgb(0,0,255)">900 \
s</span></div><div><span style="color:rgb(128,0,0)">number of transactions actually \
processed</span>: <span style="color:rgb(9,134,88)">691414</span></div><div><span \
style="color:rgb(128,0,0)">number of failed transactions</span>: <span \
style="color:rgb(0,0,255)">0 (0.000%)</span></div><div><span \
style="color:rgb(0,0,255)">latency average = 20.824 ms</span></div><div><span \
style="color:rgb(0,0,255)">initial connection time = 151.272 \
ms</span></div><div><span style="color:rgb(0,0,255)"><b>tps = 768.337953 (without \
initial connection time)</b></span></div></div> For PostgreSQL \
12:</div><div><br></div><div><div style="line-height:19px"><div>./pgbench --client=16 \
--time=900 </div><div>--host=<>.<a href="http://rds.amazonaws.com" \
rel="noreferrer noreferrer" target="_blank">rds.amazonaws.com</a> -U sa -d \
postgres</div></div> <div style="line-height:19px"><div><span \
style="color:rgb(0,0,255)">pgbench (15.3, server 12.11)</span></div><div><span \
style="color:rgb(128,0,0)">transaction type</span>: <span \
style="color:rgb(128,0,0)"><builtin</span>: <span style="color:rgb(0,0,255)">TPC-B \
(sort of)></span></div><div><span style="color:rgb(128,0,0)">scaling \
factor</span>: <span style="color:rgb(9,134,88)">1000</span></div><div><span \
style="color:rgb(128,0,0)">partition method</span>: <span \
style="color:rgb(0,0,255)">range</span></div><div><span \
style="color:rgb(128,0,0)">partitions</span>: <span \
style="color:rgb(9,134,88)">30</span></div><div><span \
style="color:rgb(128,0,0)">query mode</span>: <span \
style="color:rgb(0,0,255)">simple</span></div><div><span \
style="color:rgb(128,0,0)">number of clients</span>: <span \
style="color:rgb(9,134,88)">16</span></div><div><span \
style="color:rgb(128,0,0)">number of threads</span>: <span \
style="color:rgb(9,134,88)">1</span></div><div><span \
style="color:rgb(128,0,0)">maximum number of tries</span>: <span \
style="color:rgb(9,134,88)">1</span></div><div><span \
style="color:rgb(128,0,0)">duration</span>: <span style="color:rgb(0,0,255)">900 \
s</span></div><div><span style="color:rgb(128,0,0)">number of transactions actually \
processed</span>: <span style="color:rgb(9,134,88)">863125</span></div><div><span \
style="color:rgb(128,0,0)">number of failed transactions</span>: <span \
style="color:rgb(0,0,255)">0 (0.000%)</span></div><div><span \
style="color:rgb(0,0,255)">latency average = 16.681 ms</span></div><div><span \
style="color:rgb(0,0,255)">initial connection time = 146.719 \
ms</span></div><div><span style="color:rgb(0,0,255)"><b>tps = 959.153959 (without \
initial connection time)</b></span></div></div><div><br></div><div>I did testing \
multiple times with different connections but still the same. \
</div><div><br></div>Thanks</div><div>Srinivas</div></div></div></div> \
</blockquote></div><br clear="all"><div><br></div><span \
class="gmail_signature_prefix">-- </span><br><div dir="ltr" \
class="gmail_signature">Bert Desmet<br>0477/305361</div> \
</blockquote></div></div></div> </blockquote></div></div><span \
class="gmail_signature_prefix">-- </span><br><div dir="ltr" class="gmail_signature" \
data-smartmail="gmail_signature">Bert Desmet<br>0477/305361</div> </blockquote></div>
[prev in list] [next in list] [prev in thread] [next in thread]
Configure |
About |
News |
Add a list |
Sponsored by KoreLogic