Re: Why isn't PG using an index-only scan?

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!