Re: [PERFORM] Database connection for Tbl_B established

2007-05-30 Thread Y Sidhu
You are referring to pgpool? BTW, thanks for this insight. Yudhvir On 5/30/07, Tom Lane <[EMAIL PROTECTED]> wrote: "Y Sidhu" <[EMAIL PROTECTED]> writes: > The question is: Is this method of repeatedly establishing and > re-establishing database connections with the same 3 tables effi

Re: [PERFORM] Database connection for Tbl_B established

2007-05-30 Thread Tom Lane
"Y Sidhu" <[EMAIL PROTECTED]> 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