Re: Returning SELECTed rows immediately instead of all at the end?

On 6/13/20 12:04 AM, David G. Johnston wrote: On Friday, June 12, 2020, Ron > wrote: 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

Re: Returning SELECTed rows immediately instead of all at the end?

On 6/13/20 12:10 AM, Tom Lane wrote: Ron writes: 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, or do I have to explicitly call bt_index_check() from a shell script or SQL

Re: Returning SELECTed rows immediately instead of all at the end?

Ron writes: > 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, or do I have to explicitly call bt_index_check() from a > shell script or SQL function in order to see the

Re: Returning SELECTed rows immediately instead of all at the end?

On Friday, June 12, 2020, Ron wrote: > > 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 >

Returning SELECTed rows immediately instead of all at the end?

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, 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