Re: Database connection for Tbl_B established - Mailing list pgsql-performance

From Y Sidhu
Subject Re: Database connection for Tbl_B established
Date
Msg-id b09064f30705301636m16f0f80x21bd4be924cc812e@mail.gmail.com
Whole thread Raw
In response to Re: Database connection for Tbl_B established  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-performance
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

pgsql-performance by date:

Previous
From: Tom Lane
Date:
Subject: Re: Database connection for Tbl_B established
Next
From: "Rajesh Kumar Mallah"
Date:
Subject: Re: setting up raid10 with more than 4 drives