Hi, After a table analyzed a table, the table's relpages of pg_class gets updated, but not those of associated indexes, which can be updated by "vacuum analyze".
Is this a feature or a bug? I have some tables and there are almost only inserts. So I do not care about the "dead tuples", but do care about the statistics. Does the above "future/bug" affect the performance? My PG version is 7.3.2. Thanks, __________________________________ Do you Yahoo!? Yahoo! Domains – Claim yours for only $14.70/year http://smallbusiness.promotions.yahoo.com/offer ---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend