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-07 17:15:31
Message-ID: t2s46cc57ac1005071015g940eb775u6cdb739f3a500dbc@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 ?

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Joao Ferreira gmail 2010-05-07 17:18:19 list of databases in C ? libpq ?
Previous Message sunpeng 2010-05-07 17:13:38 what's the relation between pathkey and path in optimize phase?