Re: [PROPOSAL] extend the object names to the qualified names inpg_stat_statements

Поиск
Список
Период
Сортировка
От Christoph Berg
Тема Re: [PROPOSAL] extend the object names to the qualified names inpg_stat_statements
Дата
Msg-id 20181129094500.GD9562@msg.df7cb.de
обсуждение исходный текст
Ответ на Re: [PROPOSAL] extend the object names to the qualified names inpg_stat_statements  (Tomas Vondra <tomas.vondra@2ndquadrant.com>)
Список pgsql-hackers
Дерево обсуждения 
Re: Tomas Vondra 2018-11-28 <1b4e4c5e-7007-cd61-aae5-4a1c248e385c@2ndquadrant.com>
> Wouldn't it be sufficient / better to just store the search_path used
> when executing the query? That should be enough to resolve the object
> names correctly, and the overhead would be much lower (both in terms
> extra space and CPU overhead).

That would also work better for sub-queries from functions, if you
wanted to re-run the query in question. It's closer to reality.

Christoph

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

Предыдущее
От: John Naylor
Дата:
Сообщение: Re: WIP: Avoid creation of the free space map for small tables
Следующее
От: David Rowley
Дата:
Сообщение: Re: Planning time of Generic plan for a table partitioned into a lot