Hi Jim,
>>>>> "J" == Jim Mercer <jim(at)reptiles(dot)org> writes:
J> i suspect i've got the syntax wrong or something:
Good suspicion.
J> nagoss=> \h vacuum
J> Command: vacuum
J> Description: vacuum the database, i.e. cleans out deleted records, updates statistics
J> Syntax:
J> VACUUM [VERBOSE] [ANALYZE] [table]
J> or
J> VACUUM [VERBOSE] ANALYZE [table [(attr1, ...attrN)]];
J> what is the correct syntax for doing a vacuum analyse?
The correct syntax as shown in the help message is
'vacuum analyze'. Notice the alternative spelling of analyse with a
'z' not an 's'.
Hope you have a very nice day, :-)
Tim Ayers (tayers(at)bridge(dot)com)
Norman, Oklahoma