Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Re: SQL/MED estimated time of arrival?
On Fri, Nov 5, 2010 at 4:00 PM, Shigeru HANADA <hanada(at)metrosystems(dot)co(dot)jp> wrote: >> > * am_beginscan() -> first call of FdwRoutine.Iterate()? >> It might be good to have a separated "beginscan" method if we use >> asynchronous scans in multiple foreign servers in one query > > You mean that separated beginscan (FdwRoutine.BeginScan?) starts > asynchronous query and returns immediately, and FdwRoutine.Iterate > returns result of that query? Yes. Each BeginScan() in the executor node tree will be called at the beginning of executor's run. The callback should not block the caller. OTOH, Iterate() are called at the first time tuples in the node are required. PL/Proxy has a similar functionality with RUN ON ALL to start queries in parallel. So, I think it's a infrastructure commonly required. -- Itagaki Takahiro
In response to
- Re: SQL/MED estimated time of arrival? at 2010-11-05 07:00:07 from Shigeru HANADA
Responses
- Re: SQL/MED estimated time of arrival? at 2010-11-05 12:57:56 from Shigeru HANADA
- Re: SQL/MED estimated time of arrival? at 2010-11-08 12:08:26 from Shigeru HANADA
pgsql-hackers by date
Next: From: Daniel Farina Date: 2010-11-05 07:31:14 Subject: ALTER TABLE ... IF EXISTS feature? Previous: From: Pavel Stehule Date: 2010-11-05 07:25:46 Subject: todo: plpgsql - tool to track code coverage