allowing vacuum/ analyze to operate on whole schemas.

[Rajesh Kumar Mallah <mallah@trade-india.com>]

Greeting,

Will it be an useful feature to be able to
vacumm / analyze all tables in a given schema.

eg

VACUUM schema.* ;

at least for me it will be a good feature.

Regds
Mallah.



tradein_clients=# \h ANALYZE
Command:     ANALYZE
Description: collect statistics about a database
Syntax:
ANALYZE [ VERBOSE ] [ table [ (column [, ...] ) ] ]

tradein_clients=# \h VACUUM
Command:     VACUUM
Description: garbage-collect and optionally analyze a database
Syntax:
VACUUM [ FULL ] [ FREEZE ] [ VERBOSE ] [ table ]
VACUUM [ FULL ] [ FREEZE ] [ VERBOSE ] ANALYZE [ table [ (column [, ...] 
) ] ]


---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

              http://www.postgresql.org/docs/faqs/FAQ.html