On Wed, 2021-01-06 at 10:19 -0600, Don Seiler wrote:
> This week we've noticed that we're starting to see spikes where COMMITs are taking much longer than usual.
> Sometimes, quite a few seconds to finish.
>
> This is PostgreSQL 12.4 on Ubuntu 18.04, all running in MS Azure (*not* managed by them).
Unless you are using WITH HOLD cursors on large result sets, this is very likely
I/O overload. Use tools like "sar", "vmstat" and "iostat" to monitor your I/O load.
Yours,
Laurenz Albe
--
Cybertec | https://www.cybertec-postgresql.com