when to update pg_statistic relation? - Mailing list pgsql-general

From sunpeng
Subject when to update pg_statistic relation?
Date
Msg-id t2s46cc57ac1005071015g940eb775u6cdb739f3a500dbc@mail.gmail.com
Whole thread Raw
In response to when to update pg_statistic relation?  (sunpeng <bluevaley@gmail.com>)
List pgsql-general
when to update pg_statistic relation? is it when inserting a new tuple of any user's relations? and the relation pg_stats at document 8.4 chapter 44.55.pg_stats hasn't been used anymore ?
another question is:
I noticed when i send the sql :"select catcode from pois goup by catcode", the function :double estimate_num_groups(PlannerInfo *root, List *groupExprs, double input_rows)  uses pg_statistic.staattnum to set Agg.numGroups, then if the pg_statistic.staattnum is incorrect ,does postgresql still use this infomation to set Agg.numGroups ?

pgsql-general by date:

Previous
From: sunpeng
Date:
Subject: what's the relation between pathkey and path in optimize phase?
Next
From: Alan Hodgson
Date:
Subject: Re: postgreSQL not working after upgrade to Ubuntu 10.4