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