Re: Hide 'Execution time' in EXPLAIN (COSTS OFF)

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Hide 'Execution time' in EXPLAIN (COSTS OFF)
Дата
Msg-id 6378.1413476398@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Hide 'Execution time' in EXPLAIN (COSTS OFF)  (Ronan Dunklau <ronan.dunklau@dalibo.com>)
Список pgsql-hackers
Ronan Dunklau <ronan.dunklau@dalibo.com> writes:
> From my point of view as a FDW implementor, the feature I need is to have 
> EXPLAIN (COSTS ON) with stable output for foreign scan nodes.

Well, as long as the FDW's costing is exactly predictable, you can have
that ...

> In the Multicorn FDW (Python API on top of the C-API), we introduced this 
> commit to make the tests pass on 9.4:

> https://github.com/Kozea/Multicorn/commit/76decb360b822b57bf322892ed6c504ba44a8b28

> Clearly, we've lost the ability to test that the costs as set from the Python 
> API are indeed used. 

We did fix that yesterday.  The remaining argument is about whether it's
practical to get platform-independent output out of EXPLAIN ANALYZE.
        regards, tom lane



В списке pgsql-hackers по дате отправления:

Предыдущее
От: Stephen Frost
Дата:
Сообщение: Re: Directory/File Access Permissions for COPY and Generic File Access Functions
Следующее
От: Ryan Johnson
Дата:
Сообщение: Re: WIP: dynahash replacement for buffer table