Re: High COMMIT times - Mailing list pgsql-performance

From Don Seiler
Subject Re: High COMMIT times
Date
Msg-id CAHJZqBCQOZfMrwizFAzXYcxwVscSMp_epkk+2vCuZrxGhcpMuQ@mail.gmail.com
Whole thread Raw
In response to High COMMIT times  (Don Seiler <don@seiler.us>)
List pgsql-performance
Azure VMs do have their own IOPS limits that increase with increasing VM "size". In this current case our VM size puts that VM IOPS limit well above anything the disks are rated at, so it shouldn't be a bottleneck.

On Wed, Jan 6, 2021 at 1:15 PM Kenneth Marshall <ktm@rice.edu> wrote:
On Wed, Jan 06, 2021 at 12:06:27PM -0600, Don Seiler wrote:
> On Wed, Jan 6, 2021 at 10:51 AM Joshua Drake <jd@commandprompt.com> wrote:
>
> Looking at the Azure portal metric, we are nowhere close to the advertised
> maximum IOPS or MB/s throughput (under half of the maximum IOPS and under a
> quarter of the MB/s maximum). So there must be some other bottleneck in
> play. The IOPS limit on this VM size is even higher so that shouldn't be it.
>

Hi Don,

I may just be re-stating common knowledge, but the available IOPS would
be constrained by how tightly coupled the storage is to the CPU. Even a
small increase can limit the maximum IOPS unless you can issue multiple
relatively independent queries at one. I know no details of how Azure
implements their storage tiers.

Regards,
Ken


--
Don Seiler
www.seiler.us

pgsql-performance by date:

Previous
From: Joshua Drake
Date:
Subject: Re: High COMMIT times
Next
From: Laurenz Albe
Date:
Subject: Re: High COMMIT times