As with databases it always depends, for maximum insert performance you'd actually often go with random uuids so you dont get a hot page.
Using a monotonically increasing PK would cause pages in the index to be allocated and filled sequentially, increasing throughput.
Using random UUIDs would lead to page-splitting and partially-filled pages everywhere, negatively impacting performance and size-on-disk.
As with all databases, measure before you cut.