Re: Database connection for Tbl_B established

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Y Sidhu" <ysidhu(at)gmail(dot)com>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: Database connection for Tbl_B established
Date: 2007-05-30 22:32:11
Message-ID: 22202.1180564331@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

"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

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Y Sidhu 2007-05-30 23:36:50 Re: Database connection for Tbl_B established
Previous Message Y Sidhu 2007-05-30 21:45:07 Database connection for Tbl_B established