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

From: "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>
To: Ron <ronljohnsonjr(at)gmail(dot)com>
Cc: "pgsql-general(at)postgresql(dot)org >> PG-General Mailing List" <pgsql-general(at)postgresql(dot)org>
Subject: Re: Returning SELECTed rows immediately instead of all at the end?
Date: 2020-06-13 05:04:42
Message-ID: CAKFQuwZumhDdeS=1gO_ShaRx1VBcSz2s=-BhY-yfD3x3yfz+fw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Friday, June 12, 2020, Ron <ronljohnsonjr(at)gmail(dot)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.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2020-06-13 05:10:48 Re: Returning SELECTed rows immediately instead of all at the end?
Previous Message Ron 2020-06-13 04:39:58 Returning SELECTed rows immediately instead of all at the end?