Re: Easily reading debug_print_plan

Поиск
Список
Период
Сортировка
От Robert Haas
Тема Re: Easily reading debug_print_plan
Дата
Msg-id CA+TgmobS+C6iYQuWpH_uKyp_iDVo7S9X=JcE26mz66d_GbZgiA@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Easily reading debug_print_plan  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-hackers
On Wed, Nov 20, 2013 at 9:36 AM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
> We could in principle change to a different text representation for
> stored rules.  Compactness would be an issue if it were materially
> bigger than the existing formatting, but offhand it seems like JSON
> is morally equivalent to what we do now, no?

Yeah, but it gains a little.

{FROB :zot 3}
would become something like
{"type": "FROB", "zot": 3}

You could minimize the damage by using a single character name, like
an underscore, for the node type, and emitting all whitespace:

{"_":"FROB","zot":3}

...but it's still more.  Possibly not enough to matter, but more.

-- 
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company



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

Предыдущее
От: Peter Eisentraut
Дата:
Сообщение: Re: Proof of concept: standalone backend with full FE/BE protocol
Следующее
От: David Johnston
Дата:
Сообщение: Re: WITH ORDINALITY versus column definition lists