Hi,
On 4 October 2011 21:25, Venkat Balaji <venkat(dot)balaji(at)verse(dot)in> wrote:
> I got hold of two catalog tables "pg_stats" and "pg_class".
> Column "avg_width" and "distinct" in pg_stats gets me lot of sensible
> information regarding, column values and size of the column.
> Can someone help me know when the values in these columns are bound to
> change ? Is it only when ANALYZE runs ?
yes, ANALYZE updates underlaying pg_statistic table.
--
Ondrej Ivanic
(ondrej(dot)ivanic(at)gmail(dot)com)