Tom Lane wrote:
Ron St-Pierre <[EMAIL PROTECTED]> 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 t
Ron St-Pierre <[EMAIL PROTECTED]> 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.
Ron St-Pierre wrote:
We have a web based application with data that is updated daily. The
biggest bottleneck occurs when we try to update
one of the tables. This table contains 58,000 rows and 62 columns, and
EVERY column is indexed. Every column is
queryable (?) by the users through the web inte