From: Eden Aharoni <edena@legitsecurity.com>
To: Christophe Pettus <xof@thebuild.com>
CC: "pgsql-general@lists.postgresql.org" <pgsql-general@lists.postgresql.org>
Subject: Re: [EXTERNAL] RDS IO Read time
Thread-Topic: [EXTERNAL] RDS IO Read time
Thread-Index: AQHbomR5I1Yf228l+k24YWTefbhcZ7ONhuDJgAAIaoCAAAG0Kg==
Date: Mon, 31 Mar 2025 18:30:31 +0000
Message-ID:
 <PA6PR03MB10241624F35D0ECA4AEBA23B9BBAD2@PA6PR03MB10241.eurprd03.prod.outlook.com>
References:
 <DBBPR03MB102227BDDC40A11527BF6C0C0BBAD2@DBBPR03MB10222.eurprd03.prod.outlook.com>
 <DA3CFE03-C653-41D8-8F85-604A948C71F1@thebuild.com>
 <PA6PR03MB102418866F5C140FB0604E1EBBBAD2@PA6PR03MB10241.eurprd03.prod.outlook.com>
 <D9C6ADBF-2314-4D3F-B054-C285AB9C9C9D@thebuild.com>
 <PA6PR03MB102417C1CF1AB598D6AF4ABFBBBAD2@PA6PR03MB10241.eurprd03.prod.outlook.com>
 <D7C37263-347B-454B-8127-65C5630EEE2E@thebuild.com>
In-Reply-To: <D7C37263-347B-454B-8127-65C5630EEE2E@thebuild.com>
Accept-Language: en-US
Content-Language: en-US
x-ms-exchange-antispam-messagedata-chunkcount: 1
x-ms-exchange-antispam-messagedata-0:
 =?us-ascii?Q?vgIgqrqJo0nXJ2KisyD5tzcUMZKpjW2v4y4DtQ8UrQXKulqDTAvxxu3JIHy+?=
 =?us-ascii?Q?mx2zl0s4dirnuEXMSAN3FoaTRRhRtXIIOcZPJB3jPJPhGKjlp7XlTg5pLp/G?=
 =?us-ascii?Q?aHzFN6vCqoP/qn1irEQi0uAfg0/QXqa9cruHQzPY7ndvb9e2MMxGncdxEhzu?=
 =?us-ascii?Q?1Erc1vkZoRs3hNMQt9ZMkqlIv3j1Qcq6LWn26Zh+2UNZRWMhwfjwV4nYE8U2?=
 =?us-ascii?Q?fyu/rVYPOBrzBkJKKl+1JLm2uucUDzaOdKO1D/Q7TwIZXPuOvqPCVSaF1mfC?=
 =?us-ascii?Q?MtEnJAyYm/+XPza/KVuF7aaqDWY63jRxji2csjoHc6EpPSohlkyDa5Cp5D51?=
 =?us-ascii?Q?w5Zlz7bqimvDTSU4d/BgfARbMrEC0M0VOaHpuNbb3+uzxUn4rLm51k3v7CiG?=
 =?us-ascii?Q?s8YgrGM7MKiVkV4AryMUaGnFhqfRhA9tC0iHL+R9118zi3qwfTJO1MlhVyjh?=
 =?us-ascii?Q?doP3sRwdgkw9j64V7NiZnjzbXULfmPqRe4C3XSIEIRqjool4vSvzIshwS3le?=
 =?us-ascii?Q?miZHWgdMCX+9glt3G52MR9/ItI21h+GIT+wWkMXDBIvyo95f/GLU1iwgSiOp?=
 =?us-ascii?Q?SjKqWvLYCIXlwR9biwaqychK73qlXvkIDE2urIPleligtDFaUTPnUD1/DLx4?=
 =?us-ascii?Q?mANXwVGcjHwBlliUWoU3vCUGC1jehEZvoOX9r9ek1A4SQSss9hrrw+oKVnfS?=
 =?us-ascii?Q?FCQxqKlFg/akzbiqX697yECYVuFJc8bvHUFsnMDfPANn1kmtXSzEl6UCzZWt?=
 =?us-ascii?Q?Ru5PAhsxJf49skP6sRZ4lnv24oFOaXRTKTM1ZtDI08pTWEBARnDR17ltUUCG?=
 =?us-ascii?Q?aIZ0mYDPneZes2q0Sc+MVHjgB6luwxSKRBiFMDSlB6pG0upIx9p4Py3byE7a?=
 =?us-ascii?Q?HdHBA0QplfpxEo/fk+SRooHei1R65V/y4aVHZT+Rn4W4YJI+F93N9LFKymsR?=
 =?us-ascii?Q?eKmJLNQKVM9fAMrP8Iba1ch8zEmsaz4VPjiU9agOhdqoQcSL4GfeR++2dK/r?=
 =?us-ascii?Q?a0nfO0FYAllWTGIiNZ/sT9PlzlOw2Yk4eqVyKp+i+vYs3WBJ67l5mHp3MTQL?=
 =?us-ascii?Q?40DW77pfcbR8Pw04fz6giIaXzal6+lOImGzhbCV3nF2zfCFlLlMUWMXeSXnb?=
 =?us-ascii?Q?LnMuhXfWZw212raQIpuMgvUNelfdKAii3CJPL1g3YDXfrZASn8XpWp4JO2hd?=
 =?us-ascii?Q?k16qVrkpxSmEoG2xn5xtjcmGaUHhT4V2C/l2SVlOOSlYJ7WlBehZd7Cug2qL?=
 =?us-ascii?Q?pTaw3h6NGACfNzN3B92DSLi6bRkNhVyieVu6y+8P3rzxGGA5gSqXw8V/9Ap6?=
 =?us-ascii?Q?VXFgyovKb0GBWkapevhgW7Adlr/hxmkOvBoWawj78qPJJrXnsAcZPEAGF3g6?=
 =?us-ascii?Q?7zuCwhWv7AFUpwfY0WDWamIvyA504w8eOh0/6OP6DxOyUFLQtiba3XS4Dzlq?=
 =?us-ascii?Q?9HmLINg0tKPGGwefnd4Tz8ZTAgxvoHI2R/xoIvGOqibhTaDogMg/l6V3hNju?=
 =?us-ascii?Q?+GPEBj9LCxWBWvkek5gU+Myy8qucVEpzBHwDzBpS7LxcFsPfk6+7QaK6DS27?=
 =?us-ascii?Q?Azy0+hq1Ec+hUKkhkfUtpHvMf6/VC2YpzJ98CE47UnoOEalP/06j1pHZlggD?=
 =?us-ascii?Q?XA=3D=3D?=
Content-Type: multipart/alternative;
	boundary="_000_PA6PR03MB10241624F35D0ECA4AEBA23B9BBAD2PA6PR03MB10241eu_"
MIME-Version: 1.0
X-OriginatorOrg: legitsecurity.com
X-MS-Exchange-CrossTenant-AuthAs: Internal
X-MS-Exchange-CrossTenant-AuthSource: PA6PR03MB10241.eurprd03.prod.outlook.com
X-MS-Exchange-CrossTenant-Network-Message-Id: fccbc651-4aba-40ae-92f5-08dd70821e37
X-MS-Exchange-CrossTenant-originalarrivaltime: 31 Mar 2025 18:30:31.1288
 (UTC)
X-MS-Exchange-CrossTenant-fromentityheader: Hosted
X-MS-Exchange-CrossTenant-id: 1d036cb2-b1cc-4321-8a87-6f43158d9e1a
X-MS-Exchange-CrossTenant-mailboxtype: HOSTED
X-MS-Exchange-CrossTenant-userprincipalname: oH8xeUaaq6kdal7Vut1Vl7Cf6FzNctBqtgiFoH5BMDAUwdVl/PVfivFdKVPmfQ/rcoZ59qvxjOxfBNu7JyC6hg==
X-MS-Exchange-Transport-CrossTenantHeadersStamped: PA4PR03MB7453
List-Id: <pgsql-general.lists.postgresql.org>
List-Help: <https://lists.postgresql.org/manage/>
List-Subscribe: <https://lists.postgresql.org/manage/>
List-Post: <mailto:pgsql-general@lists.postgresql.org>
List-Owner: <mailto:pgsql-general-owner@lists.postgresql.org>
List-Archive: <https://www.postgresql.org/list/pgsql-general>
Archived-At: <https://www.postgresql.org/message-id/PA6PR03MB10241624F35D0ECA4AEBA23B9BBAD2%40PA6PR03MB10241.eurprd03.prod.outlook.com>
Precedence: bulk

--_000_PA6PR03MB10241624F35D0ECA4AEBA23B9BBAD2PA6PR03MB10241eu_
Content-Type: text/plain; charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

Can you please tell me what other data might help? Would you like an EXPLAI=
N output?

Get Outlook for Android<https://aka.ms/AAb9ysg>
________________________________
From: Christophe Pettus <xof@thebuild.com>
Sent: Monday, March 31, 2025 9:23:45 PM
To: Eden Aharoni <edena@legitsecurity.com>
Cc: pgsql-general@lists.postgresql.org <pgsql-general@lists.postgresql.org>
Subject: Re: [EXTERNAL] RDS IO Read time


> On Mar 31, 2025, at 10:54, Eden Aharoni <edena@legitsecurity.com> wrote:
>
> So you believe it's strictly an EBS issue?

Well, PostgreSQL certainly can read faster than 34MB/s off of disk.  With t=
he data you've given, I can't really say if it's purely an EBS issue.

--_000_PA6PR03MB10241624F35D0ECA4AEBA23B9BBAD2PA6PR03MB10241eu_
Content-Type: text/html; charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

<html>
<head>
<meta http-equiv=3D"Content-Type" content=3D"text/html; charset=3Dus-ascii"=
>
</head>
<body>
<div dir=3D"auto">Can you&nbsp;please tell me what other data might help? W=
ould you like an EXPLAIN output?</div>
<div id=3D"ms-outlook-mobile-body-separator-line" dir=3D"auto"><br>
</div>
<div dir=3D"auto" id=3D"ms-outlook-mobile-signature">Get <a href=3D"https:/=
/aka.ms/AAb9ysg">
Outlook for Android</a></div>
<hr style=3D"display:inline-block;width:98%" tabindex=3D"-1">
<div id=3D"divRplyFwdMsg" dir=3D"ltr"><font face=3D"Calibri, sans-serif" st=
yle=3D"font-size:11pt" color=3D"#000000"><b>From:</b> Christophe Pettus &lt=
;xof@thebuild.com&gt;<br>
<b>Sent:</b> Monday, March 31, 2025 9:23:45 PM<br>
<b>To:</b> Eden Aharoni &lt;edena@legitsecurity.com&gt;<br>
<b>Cc:</b> pgsql-general@lists.postgresql.org &lt;pgsql-general@lists.postg=
resql.org&gt;<br>
<b>Subject:</b> Re: [EXTERNAL] RDS IO Read time</font>
<div>&nbsp;</div>
</div>
<div class=3D"BodyFragment"><font size=3D"2"><span style=3D"font-size:11pt;=
">
<div class=3D"PlainText"><br>
<br>
&gt; On Mar 31, 2025, at 10:54, Eden Aharoni &lt;edena@legitsecurity.com&gt=
; wrote:<br>
&gt; <br>
&gt; So you believe it's strictly an EBS issue?<br>
<br>
Well, PostgreSQL certainly can read faster than 34MB/s off of disk.&nbsp; W=
ith the data you've given, I can't really say if it's purely an EBS issue.<=
/div>
</span></font></div>
</body>
</html>

--_000_PA6PR03MB10241624F35D0ECA4AEBA23B9BBAD2PA6PR03MB10241eu_--