Re: [PATCH] Tracking statements entry timestamp in pg_stat_statements
От
Andrei Zubkov
Тема
Re: [PATCH] Tracking statements entry timestamp in pg_stat_statements
Дата
Msg-id
e9b968e115e7683a3cac114ec88af3a0eb9a0261.camel@moonset.ru
Ответ на
Re: [PATCH] Tracking statements entry timestamp in pg_stat_statements (Michael Paquier)
Список
Дерево обсуждения
[PATCH] Tracking statements entry timestamp in pg_stat_statements Andrei Zubkov <zubkov@moonset.ru>
RE: [PATCH] Tracking statements entry timestamp in pg_stat_statements "kuroda.hayato@fujitsu.com" <kuroda.hayato@fujitsu.com>
Re: [PATCH] Tracking statements entry timestamp in pg_stat_statements Andrei Zubkov <zubkov@moonset.ru>
Re: [PATCH] Tracking statements entry timestamp in pg_stat_statements Julien Rouhaud <rjuju123@gmail.com>
Re: [PATCH] Tracking statements entry timestamp in pg_stat_statements Andrei Zubkov <zubkov@moonset.ru>
RE: [PATCH] Tracking statements entry timestamp in pg_stat_statements "kuroda.hayato@fujitsu.com" <kuroda.hayato@fujitsu.com>
Re: [PATCH] Tracking statements entry timestamp in pg_stat_statements Andrei Zubkov <zubkov@moonset.ru>
Re: [PATCH] Tracking statements entry timestamp in pg_stat_statements Seino Yuki <seinoyu@oss.nttdata.com>
Re: [PATCH] Tracking statements entry timestamp in pg_stat_statements Andrei Zubkov <zubkov@moonset.ru>
RE: [PATCH] Tracking statements entry timestamp in pg_stat_statements "kuroda.hayato@fujitsu.com" <kuroda.hayato@fujitsu.com>
Re: [PATCH] Tracking statements entry timestamp in pg_stat_statements Andrei Zubkov <zubkov@moonset.ru>
Re: [PATCH] Tracking statements entry timestamp in pg_stat_statements Julien Rouhaud <rjuju123@gmail.com>
Re: [PATCH] Tracking statements entry timestamp in pg_stat_statements Andrei Zubkov <zubkov@moonset.ru>
Re: [PATCH] Tracking statements entry timestamp in pg_stat_statements Andrei Zubkov <zubkov@moonset.ru>
Re: [PATCH] Tracking statements entry timestamp in pg_stat_statements Chengxi Sun <sunchengxi@highgo.com>
Re: [PATCH] Tracking statements entry timestamp in pg_stat_statements Andrei Zubkov <zubkov@moonset.ru>
Re[2]: [PATCH] Tracking statements entry timestamp in pg_stat_statements Мельников Антон Андреевич <aamelnikov@inbox.ru>
Re: [PATCH] Tracking statements entry timestamp in pg_stat_statements Andrei Zubkov <zubkov@moonset.ru>
Re: [PATCH] Tracking statements entry timestamp in pg_stat_statements Andrei Zubkov <zubkov@moonset.ru>
Re: [PATCH] Tracking statements entry timestamp in pg_stat_statements "Anton A. Melnikov" <aamelnikov@inbox.ru>
Hi Michael, Thank you for your attention. On Thu, 2023-03-16 at 16:13 +0900, Michael Paquier wrote: > +/* First we have to remove them from the extension */ > +ALTER EXTENSION pg_stat_statements DROP VIEW pg_stat_statements; > +ALTER EXTENSION pg_stat_statements DROP FUNCTION > pg_stat_statements(boolean); > +ALTER EXTENSION pg_stat_statements DROP FUNCTION > + pg_stat_statements_reset(Oid, Oid, bigint); > > The upgrade script of an extension is launched by the backend in the > context of an extension, so these three queries should not be needed, > as far as I recall. Agreed. I've done it as it was in previous versions. But I'm sure those are unnecessary. > Wouldn't it be better to do this kind of refactoring in its own patch > to make the follow-up changes more readable? This function is > changed > to return a timestamp rather than void, but IS NOT NULL applied on > the > existing queries would also return true. This would clean up quite a > few diffs in the main patch.. Splitting this commit seems reasonable to me. New version is attached.
В списке pgsql-hackers по дате отправления