Amit Gal
Amit Gal
I can confirm what @thomaspaulb described - original query took at least 5 hours before I manually aborted it (it never completed), new query took a few minutes. I will...
To give some context, this is all part of our migration from V8.0 to (eventually) V14.0, and I just happen to be around to do it, but my knowledge here...
My postgres version is the same as @thomaspaulb mentioned: ``` /usr/lib/postgresql/13/bin/postgres --version postgres (PostgreSQL) 13.8 (Ubuntu 13.8-1.pgdg18.04+1) ``` Following a comment from @ddejong-therp, regarding an index that exists on his...