PostgreSQL developers are contemplating an architectural overhaul to replace its process-oriented model with a multi-threaded one. Although there is optimism about such a change, especially given the limitations of the process model, some software developers are not convinced, voicing concerns over the cost in code, new bugs and maintenance. There are also suggestions that the isolation provided by separate processes would be lost, reducing the system’s robustness. The proposed changes would involve throwing all local globals into thread-local storage, a move that would add a performance penalty that could ultimately reduce the benefits of the switch to threads in the first place.
https://lwn.net/SubscriberLink/934940/3abb2d4086680b78/