agora inbox for pgsql-admin@postgresql.org
help / color / mirror / Atom feedFrom: lennam@incisivetechgroup.com
To: 'Phani Prathyush Somayajula' <phani.somayajula@pragmaticplay.com>
To: pgsql-admin@lists.postgresql.org
Subject: RE: Postgres RDS DB Parameters ::INSTANCE CLASS : db.m6id.2xlarge
Date: Tue, 18 Jun 2024 09:22:59 -0400
Message-ID: <03aa01dac182$a4879870$ed96c950$@incisivetechgroup.com> (raw)
In-Reply-To: <AS4PR10MB55452ECA456BF214261EB8398DCE2@AS4PR10MB5545.EURPRD10.PROD.OUTLOOK.COM>
References: <MAXPR01MB3328F773227E6C76B06CF21BFC22A@MAXPR01MB3328.INDPRD01.PROD.OUTLOOK.COM>
<AS4PR10MB55453EC83E81241722755F8E8D0E2@AS4PR10MB5545.EURPRD10.PROD.OUTLOOK.COM>
<AS4PR10MB55452ECA456BF214261EB8398DCE2@AS4PR10MB5545.EURPRD10.PROD.OUTLOOK.COM>
Using following url provide PostgreSQL version , type of application ,no
CPU memory , max connection , that will calculate parameter , setup like
that , re-load the cluster
https://pgtune.leopard.in.ua/
From: Phani Prathyush Somayajula <phani.somayajula@pragmaticplay.com>
Sent: Tuesday, June 18, 2024 6:38 AM
To: pgsql-admin@lists.postgresql.org
Subject: Postgres RDS DB Parameters ::INSTANCE CLASS : db.m6id.2xlarge
Hello All,
I have an AWS RDS instance of type db.m6id.2xlarge ( 8 vCPU and 32 GB RAM)
My Instance specifications are :
<https://instances.vantage.sh/aws/rds/db.m6id.2xlarge#Compute; Compute
Value
vCPUs
8
Memory (GiB)
32
Physical Processor
Intel Xeon 8375
CPU Architecture
x86
<https://instances.vantage.sh/aws/rds/db.m6id.2xlarge#Storage; Storage
Value
EBS Optimized
true
Max Bandwidth (Mbps) on
<https://handbook.vantage.sh/aws/services/ebs-pricing/; (EBS)
10000
Max Throughput (MB/s) on EBS
1250.0
Max I/O Operations/second
<https://handbook.vantage.sh/aws/concepts/io-operations/; (IOPS)
40000
Baseline Bandwidth (Mbps) on
<https://handbook.vantage.sh/aws/services/ebs-pricing/; (EBS)
2500
Baseline Throughput (MB/s) on EBS
312.5
Baseline I/O Operations/second
<https://handbook.vantage.sh/aws/concepts/io-operations/; (IOPS)
12000
<https://instances.vantage.sh/aws/rds/db.m6id.2xlarge#Networking;
Networking
Value
Network Performance (Gibps)
Up to 12.5
<https://instances.vantage.sh/aws/rds/db.m6id.2xlarge#Amazon; Amazon
Value
Generation
current
Instance Type
db.m6id.2xlarge
Family
General purpose
Name
M6ID Double Extra Large
Normalization Factor
16
I just want to crosscheck if the parameter that I set are up to the mark.
For I've verified on couple of portals, and yet the issue is that the CPU
consumption is more but not the IOPS, not the EBS throughput / iops
Now I'll share my issue:
We are seeing a lot of CPU consumption where we're load testing our
application. The query which is taking a lot of time is running less than
1ms if I run through my psql client on the server and is taking 162ms if I
run it from dBeaver.
Evidences - attached,
Querry :
I just want to analyse if the parameters that I set are optimal to the
application or not.
Regards,
Phani
Attachments:
[image/png] image002.png (558.4K, ../03aa01dac182$a4879870$ed96c950$@incisivetechgroup.com/3-image002.png)
download | view image
[image/png] image003.png (57.3K, ../03aa01dac182$a4879870$ed96c950$@incisivetechgroup.com/4-image003.png)
download | view image
view thread (5+ messages) latest in thread
Message-ID: <03aa01dac182$a4879870$ed96c950$@incisivetechgroup.com>
Permalink: ../03aa01dac182$a4879870$ed96c950$@incisivetechgroup.com/
Also on: postgresql.org/message-id/03aa01dac182$a4879870$ed96c950$@incisivetechgroup.com
reply
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: lennam@incisivetechgroup.com, phani.somayajula@pragmaticplay.com, pgsql-admin@lists.postgresql.org
Subject: RE: Postgres RDS DB Parameters ::INSTANCE CLASS : db.m6id.2xlarge
In-Reply-To: <03aa01dac182$a4879870$ed96c950$@incisivetechgroup.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox