Re: Database connection for Tbl_B established

["Y Sidhu" <ysidhu(at)gmail(dot)com>]

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

Yudhvir
========

On 5/30/07, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:

"Y Sidhu" <ysidhu(at)gmail(dot)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