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 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
