Re: pg_stat_statements vs. SELECT FOR UPDATE

Поиск
Список
Период
Сортировка
Искать
От
Tom Lane
Тема
Re: pg_stat_statements vs. SELECT FOR UPDATE
Дата
Msg-id
23804.1547944318@sss.pgh.pa.us
Ответ на
Список
Дерево обсуждения
pg_stat_statements vs. SELECT FOR UPDATE Andrew Gierth <andrew@tao11.riddles.org.uk>
Re: pg_stat_statements vs. SELECT FOR UPDATE Tom Lane <tgl@sss.pgh.pa.us>
Re: pg_stat_statements vs. SELECT FOR UPDATE Andrew Gierth <andrew@tao11.riddles.org.uk>
Re: pg_stat_statements vs. SELECT FOR UPDATE Tom Lane <tgl@sss.pgh.pa.us>
Re: pg_stat_statements vs. SELECT FOR UPDATE Andrew Gierth <andrew@tao11.riddles.org.uk>
Re: pg_stat_statements vs. SELECT FOR UPDATE Vik Fearing <vik.fearing@2ndquadrant.com>
Re: pg_stat_statements vs. SELECT FOR UPDATE Tom Lane <tgl@sss.pgh.pa.us>
Re: pg_stat_statements vs. SELECT FOR UPDATE Vik Fearing <vik.fearing@2ndquadrant.com>
Re: pg_stat_statements vs. SELECT FOR UPDATE Sergei Kornilov <sk@zsrv.org>
Re: pg_stat_statements vs. SELECT FOR UPDATE Sergei Kornilov <sk@zsrv.org>
Re: pg_stat_statements vs. SELECT FOR UPDATE Andrew Gierth <andrew@tao11.riddles.org.uk>
Re: pg_stat_statements vs. SELECT FOR UPDATE Sergei Kornilov <sk@zsrv.org>
Re: pg_stat_statements vs. SELECT FOR UPDATE Thomas Munro <thomas.munro@gmail.com>
Andrew Gierth  writes:
> "Tom" == Tom Lane  writes:
>  Tom> +1 for not ignoring rowMarks, but this patch seems like a hack to
>  Tom> me. Why didn't you just add RowMarkClause as one of the known
>  Tom> alternative expression node types?

> Because it's not an expression and nothing anywhere else in the backend
> treats it as such?

Places such as outfuncs.c and copyfuncs.c don't draw a distinction,
and I don't see why pg_stat_statements should either.  It would just
be one more place we'd have to fix if we ever allow RowMarkClause in
other places --- or, perhaps more realistically, if the structure of
Query.rowMarks becomes more complex than "flat list of RowMarkClauses".

The other places you mention generally have some specific semantic
knowledge about rowmarks, and would have to be touched anyway if any
changes like that happen.  But the jumbling code in pg_stat_statements
has no knowledge of any of that, it's just interested in traversing
the tree.  So I'd put it on the same semantic level as outfuncs.c.

			regards, tom lane

В списке pgsql-hackers по дате отправления
От: Michael Meskes
Дата:
От: Tom Lane
Дата:
FAQ