when to update pg_statistic relation?

From: sunpeng <bluevaley(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: when to update pg_statistic relation?
Date: 2010-05-05 20:50:43
Message-ID: r2x46cc57ac1005051350s6a1c523cs5691bf8ce5c447fd@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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 ?

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Magnus Hagander 2010-05-05 20:59:12 Re: LDAP: Auto user creation and role membership
Previous Message Daniel Scott 2010-05-05 20:49:43 LDAP: Auto user creation and role membership