About the portal in postgres

Started by Tanmay Deshpandealmost 12 years ago3 messages
#1Tanmay Deshpande
tp.deshpande07@gmail.com

My doubt is when the query enters into a portal, does it stay in the portal
till the final execution ? i.e. Do the further function calls such as
DefineRelation,create_heap_with_catalog etc. for Create query occur inside
the portal ?

#2Atri Sharma
atri.jiit@gmail.com
In reply to: Tanmay Deshpande (#1)
Re: About the portal in postgres

On Fri, Mar 14, 2014 at 12:29 PM, Tanmay Deshpande <tp.deshpande07@gmail.com

wrote:

My doubt is when the query enters into a portal, does it stay in the
portal till the final execution ? i.e. Do the further function calls such
as DefineRelation,create_heap_with_catalog etc. for Create query occur
inside the portal ?

What do you mean by 'Portal' ?

Regards,

Atri

#3Amit Kapila
amit.kapila16@gmail.com
In reply to: Tanmay Deshpande (#1)
Re: About the portal in postgres

On Fri, Mar 14, 2014 at 12:29 PM, Tanmay Deshpande
<tp.deshpande07@gmail.com> wrote:

My doubt is when the query enters into a portal, does it stay in the portal
till the final execution ?

Yes, portal represents the execution state of query, after the
optimizer creates the
plan, portal is used in execution of query.

With Regards,
Amit Kapila.
EnterpriseDB: http://www.enterprisedb.com

--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers