From: Tom Lane <tgl@sss.pgh.pa.us>
To: Ron St-Pierre <rstpierre@syscor.com>
Cc: pgsql-general <pgsql-general@postgresql.org>
Subject: Re: [PERFORM] Table UPDATE is too slow
Date: Tue, 07 Sep 2004 14:00:13 -0400
Message-ID: <2413.1094580013@sss.pgh.pa.us> (raw)
In-Reply-To: <413DDFB7.1060006@syscor.com>
References: <4134BF36.3000504@syscor.com>
<413DDFB7.1060006@syscor.com>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: tgl@sss.pgh.pa.us, rstpierre@syscor.com, pgsql-general@postgresql.org
Subject: Re: [PERFORM] Table UPDATE is too slow
In-Reply-To: <2413.1094580013@sss.pgh.pa.us>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox