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
