Re: Weird performance differences between cloud vendors - Mailing list pgsql-performance

From Laurenz Albe
Subject Re: Weird performance differences between cloud vendors
Date
Msg-id 6639a83ae2de2e6792066c4bc0fc34b4f9d5386b.camel@cybertec.at
Whole thread Raw
In response to Weird performance differences between cloud vendors  (Dirk Krautschick <dirk.krautschick@googlemail.com>)
List pgsql-performance
On Thu, 2024-02-01 at 10:23 +0100, Dirk Krautschick wrote:
> I have run a test with pgbench against two cloud vendors (settings, parameters almost the same).
> Both Postgres (or whatever they do internally when they call it as Postgres offering, NOT Aurora or so :-) )
>
> I have got a strange result that cloud vendor 1 is performing almost everywhere better in matter of
> read and write but except in the init phase of pgbench it took almost double the time.

Nobody except those vendors could tell you for certain, but perhaps on the one
system the initial data load is fast, because you have not yet exceeded your I/O quota,
and then I/O is throttled.

Yours,
Laurenz Albe



pgsql-performance by date:

Previous
From: Dirk Krautschick
Date:
Subject: Weird performance differences between cloud vendors
Next
From: "James Pang (chaolpan)"
Date:
Subject: huge SubtransSLRU and SubtransBuffer wait_event