Re: Make query ID more portable

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Make query ID more portable
Дата
Msg-id 570860.1634046047@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Make query ID more portable  (Andrey Lepikhov <a.lepikhov@postgrespro.ru>)
Ответы Re: Make query ID more portable  (Bruce Momjian <bruce@momjian.us>)
Re: Make query ID more portable  (Andrey Lepikhov <a.lepikhov@postgrespro.ru>)
Список pgsql-hackers
Andrey Lepikhov <a.lepikhov@postgrespro.ru> writes:
> But core jumbling code is good, fast and much easier in support.

It won't be fast once you stick a bunch of catalog lookups into it.
I think this is fine as an extension, but it has no chance of being
accepted in core, just on performance grounds.

(I'm also not sure that the query ID calculation code is always/only
invoked in contexts where it's safe to do catalog accesses.)

A bigger issue is that query ID stability isn't something we are going
to promise on a large scale --- for example, what if a new release adds
some new fields to struct Query?  So I'm not sure that "query IDs should
survive dump/reload" is a useful goal to consider.  It's certainly not
something that could be reached by anything even remotely like the
existing code.

            regards, tom lane



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

Предыдущее
От: Peter Eisentraut
Дата:
Сообщение: Re: [RFC] building postgres with meson
Следующее
От: Bruce Momjian
Дата:
Сообщение: Re: Make query ID more portable