Hi, On 4 October 2011 21:25, Venkat Balaji <venkat.bal...@verse.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.iva...@gmail.com) -- Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
