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, MaxLen 78; 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(at)reptiles(dot)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. ]