Horton
Menu

Re: FDW for PostgreSQL

Albe Laurenz <laurenz.albe@wien.gv.at>

View thread
From: "Albe Laurenz" <laurenz.albe@wien.gv.at>
To: "Kohei KaiGai *EXTERN*" <kaigai@kaigai.gr.jp>, "Shigeru Hanada" <shigeru.hanada@gmail.com>
Cc: "Etsuro Fujita" <fujita.etsuro@lab.ntt.co.jp>, "PostgreSQL-development" <pgsql-hackers@postgresql.org>
Date: 2012-11-22T09:37:52Z
Lists: pgsql-hackers 
Kohei KaiGai wrote:
> 2012/11/22 Shigeru Hanada <shigeru.hanada@gmail.com>:
>> After playing with some big SQLs for testing, I came to feel that
>> showing every remote query in EXPLAIN output is annoying, especially
>> when SELECT * is unfolded to long column list.
>>
>> AFAIK no plan node shows so many information in a line, so I'm
>> inclined to make postgres_fdw to show it only when VERBOSE was
>> specified.  This would make EXPLAIN output easy to read, even if many
>> foreign tables are used in a query.
>>
>> Thoughts?
>>
> Indeed, I also think it is reasonable solution.

+1

That's the way I do it for oracle_fdw.

Yours,
Laurenz Albe