PostgreSQL is one of the finest object-relational databases, and its architecture is process-based instead of thread-based. While almost all the current database systems utilize threads for parallelism, PostgreSQL’s process-based architecture was implemented prior to POSIX threads. PostgreSQL launches a process “postmaster” on startup, and after that spans new process whenever a new client connect
![Parallelism in PostgreSQL](https://cdn-ak-scissors.b.st-hatena.com/image/square/daa08598ecbbea3189d957331310bec5ac140892/height=288;version=1;width=512/https%3A%2F%2Fwww.percona.com%2Fblog%2Fwp-content%2Fuploads%2F2019%2F07%2FParallelisms-in-PostgreSQL.jpeg)