Re: Query performance in 9.6.24 vs 14.10

Your speedup per cent calculation undersells PG14 by quite a bit.  I'd call that an increase of ~639% rather than 86.72%.

I think you've done "1 - sum( <14.10 numbers> ) / sum( <9.6.24 numbers>)" whereas I think you should have done "sum( <9.6.24 numbers>) / sum( <14.10 numbers> ) - 1"

Nonetheless, thanks for testing this out.  I assume this is just a report giving good feedback about progress in this area...?

David