Thread: vacuum analyze [table]
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
> 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. Works here. -- Bruce Momjian | http://www.op.net/~candle pgman@candle.pha.pa.us | (610) 853-3000 + If your life is a hard drive, | 830 Blythe Avenue + Christ can be your backup. | Drexel Hill, Pennsylvania 19026