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.
Do you Yahoo!?
Yahoo! Domains Claim yours for only $14.70/year
In response to
pgsql-performance by date
|Next:||From: Litao Wu||Date: 2004-05-24 17:20:56|
|Subject: Re: index's relpages after table analyzed|
|Previous:||From: Dan Harris||Date: 2004-05-23 03:30:25|
|Subject: Re: tuning for AIX 5L with large memory|