Tom Lane wrote:
> Why not use COSTS OFF? Or I'll put that even more strongly: all the
> existing regression tests use COSTS OFF, exactly to avoid this sort of
> machine-dependent output. There had better be a really damn good
> reason not to use it here.
If we use COSTS OFF, the test is completely pointless, as the plans look
identical regardless of whether the multivariate stats are being used or
not.
If we had a ROWS option to ANALYZE that showed estimated number of rows
but not the cost, that would be an option.
--
Álvaro Herrera https://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services