Thanks David,
Le 18/09/2025 à 09:20, David Rowley a écrit :
Yes. Since *all* records of "oeu" are required and they're not
required in any particular order, then Seq Scan should be the fastest
way to access those records.
Ok but then why is it doing it on the AD table? Is it because of the
number of rows?
5 hours seems very slow for the estimated number of records. Have you
tried running the SELECT using EXPLAIN ANALYZE without the INSERT
part? Even if the 84 million Merge Join row estimate is accurate, 5
hours seems excessively long.
I tried this, it took 1 second. And then I discovered that I had an old
trigger on the copyrightad table.
The insert took 2 seconds.
Very sorry for wasting your time and thanks again for putting me on the
right track.
Have a great day!
