On Tue, 2009-12-22 at 18:11 +0900, Takahiro Itagaki wrote: > Instead, I'd suggest to have conditional database-wide maintenance > commands, something like: > VACUUM FULL WHERE <the table is fragmented> > > We don't have to support the feature by SQL syntax; it could be done > in client tools. How about pg_maintain or pg_ctl maintain that cleans > up each relation with appropriate command? We could replace vacuumdb, > clusterdb, and reindexdb with it then.
Some broad thoughts... Our perception of acceptable change is much higher than most users. If we tell people "use VACUUM FULL" or vacuumdb -f, then that command should, if possible, continue to work well across many releases. vacuumdb in most people's minds is the command you run to ease maintenance and make everything right, rather than a specific set of features. We have "It just works" as a principle. I think the corollary of that is that we should also have "It just continues to work the same way". -- Simon Riggs www.2ndQuadrant.com -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
