From PG
http://developer.postgresql.org/docs/postgres/diskusage.html:
"(Remember, relpages is only updated by VACUUM and
ANALYZE.)"
--- Litao Wu <litaowu@yahoo.com> wrote:
> 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
__________________________________
Do you Yahoo!?
Yahoo! Domains � Claim yours for only $14.70/year
http://smallbusiness.promotions.yahoo.com/offer