Hello
2014-04-25 10:48 GMT+02:00 Mehdi Ravanbakhsh <baba...@gmail.com>: > Hi All > > I have one big Pl/Pgsql function (about 1500 line code) , i can divided > it to about 5 part and call each script from main script . In this case > i need to know which way is faster . > > and some question about pgsql : > > 1- is pgsql engine open one process for each script ? > PostgreSQL uses one CPU per session. > 2- how i can chose max connection number for pgsql server based on cpu > core and RAM capacity that have maximum Efficiency? > usually max performance is about 10 x CPU connections. But it highly depends on load. Regards Pavel Stehule > > Thanks and Best ergards. >
