Max effective number of CPUs that Postgresql can handle?

Like the Subject says, is there any point of diminishing returns at which the Postmaster gets "too busy" to manage all the threads?

(I'm not in control of the stack's architecture, so "change _insert_topic_here_" -- including connection pooling -- is not in the cards.)

Thanks