On Mon, Jan 09, 2006 at 11:39:09AM -0500, Emi Lu wrote: > I'd like to vacuum all tables under a specific schema. Instead of > specifying tables one by one under the schema (not one Database), is > there a simple way to do it? VACUUM works either on a specific table or on an entire database; it doesn't have an option to vacuum a subset of tables such as all those in a particular schema. VACUUM also isn't allowed in server-side functions so you can't write a function to do the job. You could, however, write a simple client application to query the system catalogs and vacuum each table in a particular schema. Maybe that would be a useful option to add to vacuumdb. Another possibility would be to use autovacuum. -- Michael Fuhr
