Обсуждение: PostgreSQL 12 VS PostgreSQL 15
Hi Experts,
For PostgreSQL 12:
Thanks
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)
./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.
Srinivas
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.large16 GB of RAM2 vcpuBelow 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 postgresFor PostgreSQL 15:./pgbench --client=16 --time=900--host=<>.rds.amazonaws.com -U postgres -d postgresFor PostgreSQL 12:pgbench (15.3)transaction type: <builtin: TPC-B (sort of)>scaling factor: 1000partition method: rangepartitions: 30query mode: simplenumber of clients: 16number of threads: 1maximum number of tries: 1duration: 900 snumber of transactions actually processed: 691414number of failed transactions: 0 (0.000%)latency average = 20.824 msinitial connection time = 151.272 mstps = 768.337953 (without initial connection time)./pgbench --client=16 --time=900--host=<>.rds.amazonaws.com -U sa -d postgrespgbench (15.3, server 12.11)transaction type: <builtin: TPC-B (sort of)>scaling factor: 1000partition method: rangepartitions: 30query mode: simplenumber of clients: 16number of threads: 1maximum number of tries: 1duration: 900 snumber of transactions actually processed: 863125number of failed transactions: 0 (0.000%)latency average = 16.681 msinitial connection time = 146.719 mstps = 959.153959 (without initial connection time)I did testing multiple times with different connections but still the same.ThanksSrinivas
Bert Desmet
0477/305361
0477/305361
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? :)BertOn 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.large16 GB of RAM2 vcpuBelow 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 postgresFor PostgreSQL 15:./pgbench --client=16 --time=900--host=<>.rds.amazonaws.com -U postgres -d postgresFor PostgreSQL 12:pgbench (15.3)transaction type: <builtin: TPC-B (sort of)>scaling factor: 1000partition method: rangepartitions: 30query mode: simplenumber of clients: 16number of threads: 1maximum number of tries: 1duration: 900 snumber of transactions actually processed: 691414number of failed transactions: 0 (0.000%)latency average = 20.824 msinitial connection time = 151.272 mstps = 768.337953 (without initial connection time)./pgbench --client=16 --time=900--host=<>.rds.amazonaws.com -U sa -d postgrespgbench (15.3, server 12.11)transaction type: <builtin: TPC-B (sort of)>scaling factor: 1000partition method: rangepartitions: 30query mode: simplenumber of clients: 16number of threads: 1maximum number of tries: 1duration: 900 snumber of transactions actually processed: 863125number of failed transactions: 0 (0.000%)latency average = 16.681 msinitial connection time = 146.719 mstps = 959.153959 (without initial connection time)I did testing multiple times with different connections but still the same.ThanksSrinivas--Bert Desmet
0477/305361
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: 863125TPS : 959.153959In 15:Number of transactions: 691414TPS: 768.337953ThanksSrinivasOn 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? :)BertOn 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.large16 GB of RAM2 vcpuBelow 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 postgresFor PostgreSQL 15:./pgbench --client=16 --time=900--host=<>.rds.amazonaws.com -U postgres -d postgresFor PostgreSQL 12:pgbench (15.3)transaction type: <builtin: TPC-B (sort of)>scaling factor: 1000partition method: rangepartitions: 30query mode: simplenumber of clients: 16number of threads: 1maximum number of tries: 1duration: 900 snumber of transactions actually processed: 691414number of failed transactions: 0 (0.000%)latency average = 20.824 msinitial connection time = 151.272 mstps = 768.337953 (without initial connection time)./pgbench --client=16 --time=900--host=<>.rds.amazonaws.com -U sa -d postgrespgbench (15.3, server 12.11)transaction type: <builtin: TPC-B (sort of)>scaling factor: 1000partition method: rangepartitions: 30query mode: simplenumber of clients: 16number of threads: 1maximum number of tries: 1duration: 900 snumber of transactions actually processed: 863125number of failed transactions: 0 (0.000%)latency average = 16.681 msinitial connection time = 146.719 mstps = 959.153959 (without initial connection time)I did testing multiple times with different connections but still the same.ThanksSrinivas--Bert Desmet
0477/305361
Bert Desmet
0477/305361
0477/305361
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: 863125TPS : 959.153959In 15:Number of transactions: 691414TPS: 768.337953ThanksSrinivasOn 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? :)BertOn 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.large16 GB of RAM2 vcpuBelow 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 postgresFor PostgreSQL 15:./pgbench --client=16 --time=900--host=<>.rds.amazonaws.com -U postgres -d postgresFor PostgreSQL 12:pgbench (15.3)transaction type: <builtin: TPC-B (sort of)>scaling factor: 1000partition method: rangepartitions: 30query mode: simplenumber of clients: 16number of threads: 1maximum number of tries: 1duration: 900 snumber of transactions actually processed: 691414number of failed transactions: 0 (0.000%)latency average = 20.824 msinitial connection time = 151.272 mstps = 768.337953 (without initial connection time)./pgbench --client=16 --time=900--host=<>.rds.amazonaws.com -U sa -d postgrespgbench (15.3, server 12.11)transaction type: <builtin: TPC-B (sort of)>scaling factor: 1000partition method: rangepartitions: 30query mode: simplenumber of clients: 16number of threads: 1maximum number of tries: 1duration: 900 snumber of transactions actually processed: 863125number of failed transactions: 0 (0.000%)latency average = 16.681 msinitial connection time = 146.719 mstps = 959.153959 (without initial connection time)I did testing multiple times with different connections but still the same.ThanksSrinivas--Bert Desmet
0477/305361Bert Desmet
0477/305361