Hello
2014-04-25 10:48 GMT+02:00 Mehdi Ravanbakhsh <babakco@xxxxxxxxx>:
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
Pavel Stehule
Thanks and Best ergards.