RE: Postgres RDS DB Parameters ::INSTANCE CLASS : db.m6id.2xlarge

Поиск
Список
Период
Сортировка
От Phani Prathyush Somayajula
Тема RE: Postgres RDS DB Parameters ::INSTANCE CLASS : db.m6id.2xlarge
Дата
Msg-id AS4PR10MB55450CE22C30A9BF3D8B5A808DCE2@AS4PR10MB5545.EURPRD10.PROD.OUTLOOK.COM
обсуждение исходный текст
Ответ на RE: Postgres RDS DB Parameters ::INSTANCE CLASS : db.m6id.2xlarge  (<lennam@incisivetechgroup.com>)
Список pgsql-admin
Дерево обсуждения

This is awesome. Thanks Lennam  

 

Regards,

Phani

 

From: lennam@incisivetechgroup.com <lennam@incisivetechgroup.com>
Sent: Tuesday, June 18, 2024 6:53 PM
To: Phani Prathyush Somayajula <phani.somayajula@pragmaticplay.com>; pgsql-admin@lists.postgresql.org
Subject: RE: Postgres RDS DB Parameters ::INSTANCE CLASS : db.m6id.2xlarge

 

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 :

 

Compute

Value

vCPUs

8

Memory (GiB)

32

Physical Processor

Intel Xeon 8375

CPU Architecture

x86

 

Storage

Value

EBS Optimized

true

Max Bandwidth (Mbps) on (EBS)

10000

Max Throughput (MB/s) on EBS

1250.0

Max I/O Operations/second (IOPS)

40000

Baseline Bandwidth (Mbps) on (EBS)

2500

Baseline Throughput (MB/s) on EBS

312.5

Baseline I/O Operations/second (IOPS)

12000

 

Networking

Value

Network Performance (Gibps)

Up to 12.5

 

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

 

Вложения

В списке pgsql-admin по дате отправления:

Предыдущее
От:
Дата:
Сообщение: RE: Postgres RDS DB Parameters ::INSTANCE CLASS : db.m6id.2xlarge
Следующее
От: PABLO ANDRES IBARRA DUPRAT
Дата:
Сообщение: Scripting a ALTER PROCEDURE or FUNCTION to Change OWNER