| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | Ron St-Pierre <rstpierre(at)syscor(dot)com> |
| Cc: | pgsql-general <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: [PERFORM] Table UPDATE is too slow |
| Date: | 2004-09-07 18:00:13 |
| Message-ID: | 2413.1094580013@sss.pgh.pa.us |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general pgsql-performance |
Ron St-Pierre <rstpierre(at)syscor(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2004-09-07 18:03:16 | Re: ERROR: canceling query due to user request |
| Previous Message | Tom Lane | 2004-09-07 17:36:47 | Re: Salt in encrypted password in pg_shadow |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Ron St-Pierre | 2004-09-07 18:42:13 | Re: [PERFORM] Table UPDATE is too slow |
| Previous Message | Gaetano Mendola | 2004-09-07 16:54:15 | Re: The usual sequential scan, but with LIMIT ! |