Re: ALTER SET DISTINCT vs. Oracle-like DBMS_STATS

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