Postgres Pro
Downloads
Home   >   mailing lists

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

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

pgsql-performance by date:

Previous
From: "Y Sidhu"
Date:
Subject: Database connection for Tbl_B established
Next
From: "Y Sidhu"
Date:
Subject: Re: Database connection for Tbl_B established