I am new to postgresql and I am creating a c program that can receive request from different users. I want to maximize the performance of postgresql so I intend to just create 1 connection that would service all queries of different users. How do I do this?
Do I create a new connection each time there is a new request like how it goes in MySQL or can I just have one connection that is established in my `main` function?