> EXPLAIN ALTER TABLE would be the next step I guess. I discovered plenty
> of magic tricks when working on the rewriting support for that command,
> and I think exposing them in the EXPLAIN output would go a long way
> towards reducing some POLA violations.
I think this would be cool on its own merits.
However, for a very large user group -- users with ORMs which do their
own DDL migrations -- we could also use a way to log or WARN for table
rewrites. Since the ORMs are not gonna do an EXPLAIN.
--
Josh Berkus
PostgreSQL Experts Inc.
http://pgexperts.com