| From: | Joseph Shraibman <jks(at)selectacast(dot)net> |
|---|---|
| To: | "Clark, Joel" <jclark(at)lendingtree(dot)com> |
| Cc: | "'sk(at)pobox(dot)com'" <sk(at)pobox(dot)com>, pgsql-interfaces(at)postgresql(dot)org |
| Subject: | Re: Connection Pooling...(Repost)...please do help.. |
| Date: | 2000-12-19 01:18:57 |
| Message-ID: | 3A3EB781.80186971@selectacast.net |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-interfaces |
"Clark, Joel" wrote:
>
> I haven't found PG to have much connection overhead, why would open/closing
> a connection-per-query require server side connection pooling?
Each connection causes the backend to fork. With a heavy load you'll
feel the overhead of creating and closing so many connections.
--
Joseph Shraibman
jks(at)selectacast(dot)net
Increase signal to noise ratio. http://www.targabot.com
| From | Date | Subject | |
|---|---|---|---|
| postgresql : | Michael Miyabara-McCaskey | 2000-12-19 06:58:30 | postgresql : re : pl토토 베이은 pl토토 베이.o (7.0.3)에서 error1로 |
| Previous Message | Stephen Davies | 2000-12-18 23:21:24 | re:ODBC handling of bools? |