Re: SQL/MED estimated time of arrival? - Mailing list pgsql-hackers

From Tom Lane
Subject Re: SQL/MED estimated time of arrival?
Date
Msg-id 23520.1288968225@sss.pgh.pa.us
Whole thread Raw
In response to Re: SQL/MED estimated time of arrival?  (Shigeru HANADA <hanada@metrosystems.co.jp>)
Responses Re: SQL/MED estimated time of arrival?
List pgsql-hackers
Shigeru HANADA <hanada@metrosystems.co.jp> writes:
> Thanks, now I see your point.  Current FdwRoutine has no appropriate
> function because Open is called from ExecutorStart which is used by
> EXPLAIN too.

> But then we have mismatch between executor node interface and FDW
> interface about BeginScan.  Should we add new function such as
> ExecBeginNode and call ExecBeginXXX for each plan node?

That seems like a massive amount of new code, and wasted cycles during
every query startup, to fix a very small problem.

There's a flag EXEC_FLAG_EXPLAIN_ONLY that tells node Init functions
whether the query is going to be run "for real" or only EXPLAINed.
Use that to decide whether to do any real work.
        regards, tom lane


pgsql-hackers by date:

Previous
From: Shigeru HANADA
Date:
Subject: Re: SQL/MED estimated time of arrival?
Next
From: Tom Lane
Date:
Subject: Re: ALTER TABLE ... IF EXISTS feature?