| From: | "Pavel Stehule" <pavel(dot)stehule(at)gmail(dot)com> |
|---|---|
| To: | "Scott Marlowe" <scott(dot)marlowe(at)gmail(dot)com> |
| Cc: | "Josh Trutwin" <josh(at)trutwins(dot)homeip(dot)net>, pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Persistent connections in PHP |
| Date: | 2007-08-13 16:46:50 |
| Message-ID: | 162867790708130946i1e1bf87ma823c4647c903f1@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
> 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | novnov | 2007-08-13 16:47:31 | Re: Reordering columns, will this ever be simple? |
| Previous Message | Alvaro Herrera | 2007-08-13 16:38:43 | Re: "Out of memory" errors.. |