On 24.07.24 03:37, Robert Haas wrote:
On Tue, Jul 23, 2024 at 4:36 PM Peter Eisentraut <pe...@eisentraut.org> wrote:
The sorting isn't the problem. We have a versioning mechanism for
collations. What we do with the version information is clearly not
perfect yet, but the mechanism exists and you can hack together queries
that answer the question, did anything change here that would affect my
indexes. And you could build more tooling around that and so on.
In my experience, sorting is, overwhelmingly, the problem. What people
complain about is that they do an upgrade - of PG or some OS package -
and then their indexes are broken. Or their partition bounds are
broken.
Fair enough. My argument was, that topic is distinct from the topic of
this thread.
