Aside from the lack of tuning mentioned, it wasn’t mentioned what variety of UUID was used - I assume v4. If so, the visibility map impacted the performance [0].

[0]: https://www.cybertec-postgresql.com/en/unexpected-downsides-...