This seems to suggest, that if i connect to the same instance of Postgres running on my machine, multiple connections from clients are handled in parallel. Is that true?

Can I start 4 shells running psql and have their queries be handled in parrallel?

  • 1
    Yes. That's the whole point of a database server
    – user1822
    Oct 27, 2021 at 15:40
  • Can all connections come from the same machine? ODer does this lead to issues? So six shells to the same local host is not an issue? Oct 27, 2021 at 15:43
  • 2
    Yes, that’s fine. The worker threads don’t care where the connection comes from. Processes will contend with each other for resources, but it’s the same situation for any other service. It’s why we have multiprocessing operating systems.
    – dwhitemv
    Oct 27, 2021 at 16:50


Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.