I'm running amcheck on a set of indices (test machine, not prod) and want to track the progress. Is there a SELECT clause that makes rows display as they are created,
No
or do I have to explicitly call bt_index_check() from a shell script or SQL function in order to see the output as each index is checked?
You could wrap the function call in a custom plpgsql function (or just do a plpgsql loop) and side channel output via notice but i’d probably just do a shell script wrapper absent any other constraint.
David J.