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

Поиск
Список
Период
Сортировка
От David G. Johnston
Тема Re: Returning SELECTed rows immediately instead of all at the end?
Дата
Msg-id CAKFQuwZumhDdeS=1gO_ShaRx1VBcSz2s=-BhY-yfD3x3yfz+fw@mail.gmail.com
обсуждение исходный текст
Ответ на Returning SELECTed rows immediately instead of all at the end?  (Ron <ronljohnsonjr@gmail.com>)
Ответы Re: Returning SELECTed rows immediately instead of all at the end?
Список pgsql-general
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 по дате отправления:

Предыдущее
От: Ron
Дата:
Сообщение: Returning SELECTed rows immediately instead of all at the end?
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Returning SELECTed rows immediately instead of all at the end?