Re: pg_stat_statements and "IN" conditions
От
Dmitry Dolgov
Тема
Re: pg_stat_statements and "IN" conditions
Дата
Msg-id
20230211120820.y7krq37jubnjsa5b@erthalion.local
Ответ на
Re: pg_stat_statements and "IN" conditions (Dmitry Dolgov)
Список
Дерево обсуждения
pg_stat_statements and "IN" conditions Dmitry Dolgov <9erthalion6@gmail.com>
Re: pg_stat_statements and "IN" conditions Dmitry Dolgov <9erthalion6@gmail.com>
Re: pg_stat_statements and "IN" conditions Chengxi Sun <sunchengxi@highgo.com>
Re: pg_stat_statements and "IN" conditions Dmitry Dolgov <9erthalion6@gmail.com>
Re: pg_stat_statements and "IN" conditions Dmitry Dolgov <9erthalion6@gmail.com>
Re: pg_stat_statements and "IN" conditions Zhihong Yu <zyu@yugabyte.com>
Re: pg_stat_statements and "IN" conditions Dmitry Dolgov <9erthalion6@gmail.com>
Re: pg_stat_statements and "IN" conditions Zhihong Yu <zyu@yugabyte.com>
Re: pg_stat_statements and "IN" conditions David Steele <david@pgmasters.net>
Re: pg_stat_statements and "IN" conditions Dmitry Dolgov <9erthalion6@gmail.com>
Re: pg_stat_statements and "IN" conditions Dmitry Dolgov <9erthalion6@gmail.com>
Re: pg_stat_statements and "IN" conditions Dmitry Dolgov <9erthalion6@gmail.com>
Re: pg_stat_statements and "IN" conditions Dmitry Dolgov <9erthalion6@gmail.com>
Re: pg_stat_statements and "IN" conditions Zhihong Yu <zyu@yugabyte.com>
Re: pg_stat_statements and "IN" conditions Dmitry Dolgov <9erthalion6@gmail.com>
Re: pg_stat_statements and "IN" conditions Tom Lane <tgl@sss.pgh.pa.us>
Re: pg_stat_statements and "IN" conditions Dmitry Dolgov <9erthalion6@gmail.com>
Re: pg_stat_statements and "IN" conditions Dmitry Dolgov <9erthalion6@gmail.com>
Re: pg_stat_statements and "IN" conditions Tom Lane <tgl@sss.pgh.pa.us>
Re: pg_stat_statements and "IN" conditions Dmitry Dolgov <9erthalion6@gmail.com>
Re: pg_stat_statements and "IN" conditions Robert Haas <robertmhaas@gmail.com>
Re: pg_stat_statements and "IN" conditions Dmitry Dolgov <9erthalion6@gmail.com>
Re: pg_stat_statements and "IN" conditions Robert Haas <robertmhaas@gmail.com>
Re: pg_stat_statements and "IN" conditions Tom Lane <tgl@sss.pgh.pa.us>
Re: pg_stat_statements and "IN" conditions Dmitry Dolgov <9erthalion6@gmail.com>
Re: pg_stat_statements and "IN" conditions Tom Lane <tgl@sss.pgh.pa.us>
Re: pg_stat_statements and "IN" conditions Dmitry Dolgov <9erthalion6@gmail.com>
Re: pg_stat_statements and "IN" conditions Dmitry Dolgov <9erthalion6@gmail.com>
Re: pg_stat_statements and "IN" conditions Dmitry Dolgov <9erthalion6@gmail.com>
Re:pg_stat_statements and "IN" conditions Sergei Kornilov <sk@zsrv.org>
Re: pg_stat_statements and "IN" conditions Dmitry Dolgov <9erthalion6@gmail.com>
Re: pg_stat_statements and "IN" conditions Dmitry Dolgov <9erthalion6@gmail.com>
Re: pg_stat_statements and "IN" conditions vignesh C <vignesh21@gmail.com>
Re: pg_stat_statements and "IN" conditions Dmitry Dolgov <9erthalion6@gmail.com>
Re: pg_stat_statements and "IN" conditions Marcos Pegoraro <marcos@f10.com.br>
Re: pg_stat_statements and "IN" conditions Dmitry Dolgov <9erthalion6@gmail.com>
Re: pg_stat_statements and "IN" conditions Alvaro Herrera <alvherre@alvh.no-ip.org>
Re: pg_stat_statements and "IN" conditions Dmitry Dolgov <9erthalion6@gmail.com>
Re: pg_stat_statements and "IN" conditions Dmitry Dolgov <9erthalion6@gmail.com>
Re: pg_stat_statements and "IN" conditions Michael Paquier <michael@paquier.xyz>
Re: pg_stat_statements and "IN" conditions Dmitry Dolgov <9erthalion6@gmail.com>
Re: pg_stat_statements and "IN" conditions Tom Lane <tgl@sss.pgh.pa.us>
Re: pg_stat_statements and "IN" conditions Dmitry Dolgov <9erthalion6@gmail.com>
Re:pg_stat_statements and "IN" conditions Sergei Kornilov <sk@zsrv.org>
Re: pg_stat_statements and "IN" conditions Dmitry Dolgov <9erthalion6@gmail.com>
Re: pg_stat_statements and "IN" conditions David Geier <geidav.pg@gmail.com>
Re: pg_stat_statements and "IN" conditions Dmitry Dolgov <9erthalion6@gmail.com>
Re: pg_stat_statements and "IN" conditions Dmitry Dolgov <9erthalion6@gmail.com>
Re: pg_stat_statements and "IN" conditions David Geier <geidav.pg@gmail.com>
Re: pg_stat_statements and "IN" conditions Dmitry Dolgov <9erthalion6@gmail.com>
Re: pg_stat_statements and "IN" conditions David Geier <geidav.pg@gmail.com>
Re: pg_stat_statements and "IN" conditions Dmitry Dolgov <9erthalion6@gmail.com>
Re: pg_stat_statements and "IN" conditions "Gregory Stark (as CFM)" <stark.cfm@gmail.com>
Re: pg_stat_statements and "IN" conditions Dmitry Dolgov <9erthalion6@gmail.com>
Re: pg_stat_statements and "IN" conditions Dmitry Dolgov <9erthalion6@gmail.com>
Re: pg_stat_statements and "IN" conditions Nathan Bossart <nathandbossart@gmail.com>
Re: pg_stat_statements and "IN" conditions Dmitry Dolgov <9erthalion6@gmail.com>
Re: pg_stat_statements and "IN" conditions Jakub Wartak <jakub.wartak@enterprisedb.com>
Re: pg_stat_statements and "IN" conditions Maciek Sakrejda <m.sakrejda@gmail.com>
Re: pg_stat_statements and "IN" conditions Yasuo Honda <yasuo.honda@gmail.com>
Re: pg_stat_statements and "IN" conditions Nathan Bossart <nathandbossart@gmail.com>
Re: pg_stat_statements and "IN" conditions Michael Paquier <michael@paquier.xyz>
Re: pg_stat_statements and "IN" conditions Dmitry Dolgov <9erthalion6@gmail.com>
Re: pg_stat_statements and "IN" conditions Dmitry Dolgov <9erthalion6@gmail.com>
Re: pg_stat_statements and "IN" conditions Michael Paquier <michael@paquier.xyz>
Re: pg_stat_statements and "IN" conditions Dmitry Dolgov <9erthalion6@gmail.com>
Re: pg_stat_statements and "IN" conditions Dmitry Dolgov <9erthalion6@gmail.com>
Re: pg_stat_statements and "IN" conditions vignesh C <vignesh21@gmail.com>
Re: pg_stat_statements and "IN" conditions Dmitry Dolgov <9erthalion6@gmail.com>
Re: pg_stat_statements and "IN" conditions Dmitry Dolgov <9erthalion6@gmail.com>
Re: pg_stat_statements and "IN" conditions Peter Smith <smithpb2250@gmail.com>
Re: pg_stat_statements and "IN" conditions Dmitry Dolgov <9erthalion6@gmail.com>
Re: pg_stat_statements and "IN" conditions Tom Lane <tgl@sss.pgh.pa.us>
Re: pg_stat_statements and "IN" conditions Dmitry Dolgov <9erthalion6@gmail.com>
Re: pg_stat_statements and "IN" conditions Dmitry Dolgov <9erthalion6@gmail.com>
Re: pg_stat_statements and "IN" conditions Yasuo Honda <yasuo.honda@gmail.com>
Re: pg_stat_statements and "IN" conditions Dmitry Dolgov <9erthalion6@gmail.com>
Re: pg_stat_statements and "IN" conditions Yasuo Honda <yasuo.honda@gmail.com>
Re: pg_stat_statements and "IN" conditions Dmitry Dolgov <9erthalion6@gmail.com>
Re: pg_stat_statements and "IN" conditions Yasuo Honda <yasuo.honda@gmail.com>
Re: pg_stat_statements and "IN" conditions Dmitry Dolgov <9erthalion6@gmail.com>
Re: pg_stat_statements and "IN" conditions Yasuo Honda <yasuo.honda@gmail.com>
Re: pg_stat_statements and "IN" conditions Dmitry Dolgov <9erthalion6@gmail.com>
Re: pg_stat_statements and "IN" conditions Sutou Kouhei <kou@clear-code.com>
Re: pg_stat_statements and "IN" conditions Dmitry Dolgov <9erthalion6@gmail.com>
Re: pg_stat_statements and "IN" conditions Dmitry Dolgov <9erthalion6@gmail.com>
Re: pg_stat_statements and "IN" conditions Sergei Kornilov <sk@zsrv.org>
Re: pg_stat_statements and "IN" conditions Dmitry Dolgov <9erthalion6@gmail.com>
Re: pg_stat_statements and "IN" conditions Dmitry Dolgov <9erthalion6@gmail.com>
Re: pg_stat_statements and "IN" conditions Kirill Reshke <reshkekirill@gmail.com>
Re: pg_stat_statements and "IN" conditions Peter Eisentraut <peter.eisentraut@enterprisedb.com>
Re: pg_stat_statements and "IN" conditions Dmitry Dolgov <9erthalion6@gmail.com>
Re: pg_stat_statements and "IN" conditions Alvaro Herrera <alvherre@alvh.no-ip.org>
Re: pg_stat_statements and "IN" conditions Dmitry Dolgov <9erthalion6@gmail.com>
Re: pg_stat_statements and "IN" conditions Dmitry Dolgov <9erthalion6@gmail.com>
Re: pg_stat_statements and "IN" conditions Dmitry Dolgov <9erthalion6@gmail.com>
Re: pg_stat_statements and "IN" conditions Robert Haas <robertmhaas@gmail.com>
Re: pg_stat_statements and "IN" conditions Dmitry Dolgov <9erthalion6@gmail.com>
Re: pg_stat_statements and "IN" conditions "Andrey V. Lepikhov" <a.lepikhov@postgrespro.ru>
Re: pg_stat_statements and "IN" conditions Tom Lane <tgl@sss.pgh.pa.us>
> On Sat, Feb 11, 2023 at 11:47:07AM +0100, Dmitry Dolgov wrote: > > The original version of the patch was doing all of this, i.e. handling > numerics, Param nodes, RTE_VALUES. The commentary about > find_const_walker in tests is referring to a part of that, that was > dealing with evaluation of expression to see if it could be reduced to a > constant. > > Unfortunately there was a significant push back from reviewers because > of those features. That's why I've reduced the patch to it's minimally > useful version, having in mind re-implementing them as follow-up patches > in the future. This is the reason as well why I left tests covering all > this missing functionality -- as breadcrumbs to already discovered > cases, important for the future extensions. I'd like to elaborate on this a bit and remind about the origins of the patch, as it's lost somewhere in the beginning of the thread. The idea is not pulled out of thin air, everything is coming from our attempts to improve one particular monitoring infrastructure in a real commercial setting. Every covered use case and test in the original proposal was a result of field trials, when some application-side library or ORM was responsible for gigabytes of data in pgss, chocking the monitoring agent.
В списке pgsql-hackers по дате отправления
От: Ankit Kumar Pandey
Дата: