>From PG
http://developer.postgresql.org/docs/postgres/diskusage.html:

"(Remember, relpages is only updated by VACUUM and
ANALYZE.)"


--- Litao Wu <[EMAIL PROTECTED]> 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 

---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]

Reply via email to