Jesse Long wrote:
> There is no problem with row visibility, there is only one connection to
> the database - the connection I am using to do these selects.
No idea why the plans cannot be used.
It might be helpful to see the table and index definitions.
> Thanks you for the advise regarding ANALYZE. I ran ANALYZE on both
> tables concerned, but not much changed:
Did you try increasing default_statistics_target before ANALYZE?
Yours,
Laurenz Albe