Itagaki Takahiro escribió: > It is just similar to Oracle's DBMS_STATS package. > http://download.oracle.com/docs/cd/B28359_01/appdev.111/b28419/d_stats.htm > If it were, "ALTER TABLE tablename ALTER COLUMN 3rd-column SET DISITNCT 100" > could be written as: > > INSERT INTO dbms_stats.columns(starelid, ataattnum, stadistinct) > VALUES ('tablename'::regclass, 3, 100); > > Of course ALTER SET DISTINCT is easy-to-use, so it could be an alias for > the above INSERT command.
Why wouldn't you implement this through reloptions? (I ask because the syntax you propose above is awfully similar to what we used for pg_autovacuum, which ended up being replaced by reloptions) -- Alvaro Herrera http://www.CommandPrompt.com/ PostgreSQL Replication, Consulting, Custom Development, 24x7 support -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
