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

[PERFORM] Database connection for Tbl_B established

2007-05-30 Thread Y Sidhu
I have a question regarding "connection for xxyy established" The situation below shows records being added to 3 tables which are heavily populated. We never "update" any table, only read from them. Or we delete a full-day worth of records from them. The question is: Is this method of repeatedly