I use the null uuid as primary key - never had any DB scaling issues.

Yeah, no NULL is ever equal to any other NULL, so they are basically unique.

You are also guaranteed to be able to retrieve your data, just query for '... is null'. No complicated logic needed!

Me still using bigints... Which haven't given me any problems. Wouldn't use it for client generated IDs but that is not what most applications require anyway.