Hi, > I have fear that sufficient increase in number of postgres.exe after one > or two logins on servers may down the speed of the server or even server. Is > there any solution or technique to overcome this overhead. >
Did you test this? What OS are you using? With PostgreSQL every connection gets a process, processes can be reused, so unless you have a very low spec system, that should not be a problem. PostgreSQL is designed as a client/server architecture, which requires > separate processes for each client and server, and various helper processes. > Many embedded architectures can support such requirements. However, if your > embedded architecture requires the database server to run inside the > application process, you cannot use Postgres and should select a > lighter-weight database solution. > I could not find the reason as to why this way has been chosen by the developers Hope this helps Regards, Serge Fonville