Hi, On 4 October 2011 21:25, Venkat Balaji <[email protected]> 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 ([email protected]) -- Sent via pgsql-performance mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
