Am I the only one who cannot vacuum a named table? (Does it make sense to
just vacuum a single table?)
regression=> \h vacuum
Command: VACUUM
Description: Clean and analyze a Postgres database
Syntax:
VACUUM [ VERBOSE ] [ ANALYZE ] [ table ]
VACUUM [ VERBOSE ] ANALYZE [ table [ (column [, ...] ) ] ]
regression=> vacuum analyze num_result;
NOTICE: Vacuum: table not found
VACUUM
The same is true for me with any table, any database, using source cvs'd
yesterday.
Cheers,
Patrick