Search Postgresql Archives

when to update pg_statistic relation?

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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 ?


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux