Postgres Pro
Downloads
Home   >   mailing lists

Re: Returning SELECTed rows immediately instead of all at the end? - Mailing list pgsql-general

From David G. Johnston
Subject Re: Returning SELECTed rows immediately instead of all at the end?
Date
Msg-id CAKFQuwZumhDdeS=1gO_ShaRx1VBcSz2s=-BhY-yfD3x3yfz+fw@mail.gmail.com
Whole thread Raw
In response to Returning SELECTed rows immediately instead of all at the end?  (Ron <ronljohnsonjr@gmail.com>)
Responses Re: Returning SELECTed rows immediately instead of all at the end?
List pgsql-general
Tree view
On Friday, June 12, 2020, Ron <ronljohnsonjr@gmail.com> 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 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.

pgsql-general by date:

Previous
From: Ron
Date:
Subject: Returning SELECTed rows immediately instead of all at the end?
Next
From: Tom Lane
Date:
Subject: Re: Returning SELECTed rows immediately instead of all at the end?