Re: [EXTERNAL] RDS IO Read time

2025-04-05 Thread Christophe Pettus
> On Mar 31, 2025, at 12:36, Eden Aharoni wrote: > Hope you’ll have any clue 😊 Based on that, I'd take it up with AWS. It does seem that the EBS mount is under-performing.

Re: [EXTERNAL] RDS IO Read time

2025-04-05 Thread Adrian Klaver
On 3/31/25 11:23 AM, Christophe Pettus wrote: On Mar 31, 2025, at 10:54, Eden Aharoni wrote: So you believe it's strictly an EBS issue? You are asking about disk I/O, that is the purview of the OS and hardware. In your case both are created and managed by AWS, only they know what is g

Re: [EXTERNAL] RDS IO Read time

2025-04-04 Thread Christophe Pettus
> On Mar 31, 2025, at 11:30, Eden Aharoni wrote: > > Can you please tell me what other data might help? You can show your work on how you got the megabytes/second number. (Be aware that on a general open-source mailing list, there's only so much debugging that we can do of a specific probl

Re: [EXTERNAL] Re: RDS IO Read time

2025-04-01 Thread Eden Aharoni
path won't lead anywhere). Thanks again Get Outlook for Android<https://aka.ms/AAb9ysg> From: Christophe Pettus Sent: Monday, March 31, 2025 6:15:39 PM To: Eden Aharoni Cc: pgsql-general@lists.postgresql.org Subject: [EXTERNAL] Re: RDS IO Read tim

Re: [EXTERNAL] RDS IO Read time

2025-04-01 Thread Eden Aharoni
ubject: Re: [EXTERNAL] RDS IO Read time > On Mar 31, 2025, at 10:54, Eden Aharoni wrote: > > So you believe it's strictly an EBS issue? Well, PostgreSQL certainly can read faster than 34MB/s off of disk. With the data you've given, I can't really say if it's purely an EBS issue.

Re: [EXTERNAL] RDS IO Read time

2025-04-01 Thread Eden Aharoni
sec.. (ive done 4314 * 8kb / 1.2sec which is about 28 MB/s)… Hope you’ll have any clue 😊 From: Christophe Pettus Date: Monday, 31 March 2025 at 21:44 To: Eden Aharoni Cc: pgsql-general@lists.postgresql.org Subject: Re: [EXTERNAL] RDS IO Read time > On Mar 31, 2025, at 11:30, Eden Aharoni

Re: [EXTERNAL] RDS IO Read time

2025-04-01 Thread Eden Aharoni
So you believe it's strictly an EBS issue? Get Outlook for Android<https://aka.ms/AAb9ysg> From: Christophe Pettus Sent: Monday, March 31, 2025 8:43:19 PM To: Eden Aharoni Cc: pgsql-general@lists.postgresql.org Subject: Re: [EXTERNAL] RDS IO Read

Re: [EXTERNAL] RDS IO Read time

2025-03-31 Thread Christophe Pettus
> On Mar 31, 2025, at 10:54, Eden Aharoni wrote: > > So you believe it's strictly an EBS issue? Well, PostgreSQL certainly can read faster than 34MB/s off of disk. With the data you've given, I can't really say if it's purely an EBS issue.

Re: RDS IO Read time

2025-03-31 Thread Christophe Pettus
> On Mar 31, 2025, at 06:54, Eden Aharoni wrote: > Is this expected IO read rate? I can’t help but feel we’re missing something > here.. Really, no particular I/O rate is "expected": if PostgreSQL needs that much data, it'll use that much I/O to get it. From your description, it's likely t

Re: [EXTERNAL] RDS IO Read time

2025-03-31 Thread Christophe Pettus
> On Mar 31, 2025, at 10:32, Eden Aharoni wrote: > > First, thanks for the reply :) > So, I do know which part is taking a lot of IO time and it's to be honest any > node that reads from the disk.. of course, we're running EXPLAIN on our > queries (to be more specific we use auto_explain) bu

RDS IO Read time

2025-03-31 Thread Eden Aharoni
Hi all, Hopefully, someone here could help us understand whats going on with our deployment.. We are running Postgres 17.4 on AWS RDS on an ec2 instance that has: * 32vCPU * 128GB RAM * gp3 with 25K IOPS and 4000MiB/s throughput * the instance supports up to 3125GB/s of throughput

Re: RDS IO Read time

2025-03-31 Thread Adrian Klaver
On 3/31/25 06:54, Eden Aharoni wrote: Hi all, Hopefully, someone here could help us understand whats going on with our deployment.. We are running Postgres 17.4 on AWS RDS on an ec2 instance that has: * 32vCPU * 128GB RAM * gp3 with 25K IOPS and 4000MiB/s throughput * the instance su