You are referring to pgpool? BTW, thanks for this insight.

Yudhvir
========

On 5/30/07, Tom Lane <tgl@sss.pgh.pa.us> wrote:
>
> "Y Sidhu" <ysidhu@gmail.com> writes:
> > The question is: Is this method of repeatedly establishing and
> > re-establishing database connections with the same 3 tables efficient?
>
> No. Launching a new backend process is a fairly expensive proposition;
> if you're striving for performance you don't want to do it for just one
> or two queries. Look into connection pooling ...
>
> regards, tom lane
>



--
Yudhvir Singh Sidhu
408 375 3134 cell