Re: [GENERAL] [PERFORM] Table UPDATE is too slow

2004-09-07 Thread Ron St-Pierre
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

Re: [GENERAL] [PERFORM] Table UPDATE is too slow

2004-09-07 Thread Tom Lane
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.

Re: [GENERAL] [PERFORM] Table UPDATE is too slow

2004-09-07 Thread Ron St-Pierre
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