Re: [PERFORM] Table UPDATE is too slow - Mailing list pgsql-general

From Tom Lane
Subject Re: [PERFORM] Table UPDATE is too slow
Date
Msg-id 2413.1094580013@sss.pgh.pa.us
Whole thread Raw
In response to Re: [PERFORM] Table UPDATE is too slow  (Ron St-Pierre <rstpierre@syscor.com>)
List 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 by date:

Previous
From: Tom Lane
Date:
Subject: Re: Salt in encrypted password in pg_shadow
Next
From: Tom Lane
Date:
Subject: Re: ERROR: canceling query due to user request