Re: Make query ID more portable - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Make query ID more portable
Date
Msg-id 570860.1634046047@sss.pgh.pa.us
Whole thread Raw
In response to Re: Make query ID more portable  (Andrey Lepikhov <a.lepikhov@postgrespro.ru>)
Responses Re: Make query ID more portable  (Bruce Momjian <bruce@momjian.us>)
Re: Make query ID more portable  (Andrey Lepikhov <a.lepikhov@postgrespro.ru>)
List 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 by date:

Previous
From: Peter Eisentraut
Date:
Subject: Re: [RFC] building postgres with meson
Next
From: Bruce Momjian
Date:
Subject: Re: Make query ID more portable