when to update pg_statistic relation?

Поиск
Список
Период
Сортировка
От sunpeng
Тема when to update pg_statistic relation?
Дата
Msg-id t2s46cc57ac1005071015g940eb775u6cdb739f3a500dbc@mail.gmail.com
обсуждение исходный текст
Ответ на when to update pg_statistic relation?  (sunpeng <bluevaley@gmail.com>)
Список 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 по дате отправления:

Предыдущее
От: sunpeng
Дата:
Сообщение: what's the relation between pathkey and path in optimize phase?
Следующее
От: Alan Hodgson
Дата:
Сообщение: Re: postgreSQL not working after upgrade to Ubuntu 10.4