Litao Wu <[EMAIL PROTECTED]> writes:
> My question is why relpages of indexes
> do not get updated after "analyze".
It's an oversight, which just got fixed in CVS tip a few weeks ago.
regards, tom lane
---(end of broadcast)-
Hi Josh,
I know that and that is what I am using now.
The problem is I also need to know
the relpages each indexe takes and "analyze"
seems not update relpages though vacuum and
vacuum analyze do.
According to PG doc:
"Remember, relpages is only updated by VACUUM and
ANALYZE"
My question is wh
Litao,
> 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.
Then just run ANALYZE on those tables, and not VACUUM.
ANALYZE ;
> My PG version is 7.3.2.
I would suggest upgrading to 7.3.6; the version you are usin
>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
> associat
