Re: [PERFORM] Table UPDATE is too slow

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: [PERFORM] Table UPDATE is too slow
Дата
Msg-id 2413.1094580013@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: [PERFORM] Table UPDATE is too slow  (Ron St-Pierre <rstpierre@syscor.com>)
Список pgsql-general
Ron St-Pierre <rstpierre@syscor.com> writes:
> One question about redirecting VACUUMs output to file though. When I run:
>    psql -d imperial -c "vacuum full verbose analyze;" > vac.info
> vac.info contains only the following line:
>    VACUUM
> I've been unable to capture the VERBOSE output to file. Any suggestions?

You need to catch stderr not only stdout.

(I'd be less vague if I knew which shell you were running, but sh- and
csh-derived shells do it differently.)

            regards, tom lane

В списке pgsql-general по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Salt in encrypted password in pg_shadow
Следующее
От: Tom Lane
Дата:
Сообщение: Re: ERROR: canceling query due to user request