> 6: The reason for connection pooling is primarily to twofold. One is > to allow very fast connections to your database when doing lots of > small things where connection time will cost too much. The other is > to prevent your database from having lots of stale / idle connections > that cause it to waste memory and to be slower since each backend > needs to communicate with every other backend some amount of data some > times. pconnect takes care of the first problem, but exacerbates the > second. > next advance ... longer life of cached executive plans in PL/pgSQL procedures. Regards Pavel Stehule ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings
