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

Поиск
Список
Период
Сортировка
От legrand legrand
Тема Re: [PROPOSAL] extend the object names to the qualified names inpg_stat_statements
Дата
Msg-id 1543483408140-0.post@n3.nabble.com
обсуждение исходный текст
Ответ на Re: [PROPOSAL] extend the object names to the qualified names inpg_stat_statements  (Alvaro Herrera <alvherre@2ndquadrant.com>)
Список pgsql-hackers
Alvaro Herrera-9 wrote
> On 2018-Nov-28, Tom Lane wrote:
> 
>> This would also entail rather significant overhead to find out schema
>> names and interpolate them into the text.
> 
> True.  I was thinking that the qualified-names version of the query
> would be obtained via ruleutils or some similar mechanism to deparse
> from the parsed query tree (not from the original query text), where
> only pg_catalog is considered visible.  This would be enabled using a
> GUC that defaults to off.

maybe that explain on "table with many columns" suffers from the same 
problem, see:

https://www.postgresql.org/message-id/1537816948278-0.post%40n3.nabble.com

https://www.postgresql.org/message-id/20180924195048.7dhnjvq5ggwjtiwi@alap3.anarazel.de

regards
PAscal



--
Sent from: http://www.postgresql-archive.org/PostgreSQL-hackers-f1928748.html


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

Предыдущее
От: Michael Paquier
Дата:
Сообщение: Re: [PATCH] Change "checkpoint starting" message to use "wal"
Следующее
От: "Iwata, Aya"
Дата:
Сообщение: RE: libpq debug log