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

On Wed, Jan 12, 2000 at 12:23:23PM -0400, The Hermit Hacker wrote:
> Have/do you perform reasonably regular vacuum's of the database?

on my databases, i have only been successful in doing a "VACUUM VERBOSE" on
my tables.

i suspect i've got the syntax wrong or something:

nagoss=> \h vacuum
Command: vacuum
Description: vacuum the database, i.e. cleans out deleted records, updates statistics
Syntax:
        VACUUM [VERBOSE] [ANALYZE] [table]
        or
        VACUUM [VERBOSE]  ANALYZE  [table [(attr1, ...attrN)]];

nagoss=> vacuum verbose analyse switches;
ERROR:  parser: parse error at or near "switches"
nagoss=> vacuum verbose switches;
NOTICE:  --Relation switches--
NOTICE:  Pages 1: Changed 1, Reapped 0, Empty 0, New 0; Tup 9: Vac 0, Keep/VTL 0/0, Crash 0, UnUsed 0, MinLen 78,
MaxLen78; Re-using: Free/Avail. Space 0/0; EndEmpty/Avail. Pages 0/0. Elapsed 0/0 sec. 
NOTICE:  Index switch_name: Pages 2; Tuples 9. Elapsed 0/0 sec.
VACUUM

what is the correct syntax for doing a vacuum analyse?

--
[ Jim Mercer                 jim@reptiles.org              +1 416 506-0654 ]
[          Reptilian Research -- Longer Life through Colder Blood          ]
[  Don't be fooled by cheap Finnish imitations; BSD is the One True Code.  ]