Re: [GENERAL] identifying performance hits: how to ???

Hi Jim,

>>>>> "J" == Jim Mercer <jim@reptiles.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@bridge.com)
Norman, Oklahoma