I'm not sure what exactly you mean by "thread" here. Postgres is not thread-based - there are people working on that, but for now it's all processes.
Some of these limitations are mostly due to Postgres design, no doubt about that.
Some of these limitations are mostly due to Postgres design, no doubt about that.
If there are no threads then this would be, you can have a process per cpu core