Re: using extended statistics to improve join estimates

Поиск
Список
Период
Сортировка
От Andy Fan
Тема Re: using extended statistics to improve join estimates
Дата
Msg-id 87le4yjkvn.fsf@163.com
обсуждение исходный текст
Ответ на Re: using extended statistics to improve join estimates  (Justin Pryzby <pryzby@telsasoft.com>)
Ответы Re: using extended statistics to improve join estimates  (Justin Pryzby <pryzby@telsasoft.com>)
Список pgsql-hackers
Hello Justin!

Justin Pryzby <pryzby@telsasoft.com> writes:


> |../src/backend/statistics/extended_stats.c:3151:36: warning: ‘relid’ may be used uninitialized
[-Wmaybe-uninitialized]
> | 3151 |                                 if (var->varno != relid)
> |      |                                    ^
> |../src/backend/statistics/extended_stats.c:3104:33: note: ‘relid’ was declared here
> | 3104 |         int                     relid;
> |      |                                 ^~~~~
> |[1016/1893] Compiling C object src/backend/postgres_lib.a.p/statistics_mcv.c.o
> |../src/backend/statistics/mcv.c: In function ‘mcv_combine_extended’:
> |../src/backend/statistics/mcv.c:2431:49: warning: declaration of ‘idx’ shadows a previous local
[-Wshadow=compatible-local]

Thanks for the feedback, the warnning should be fixed in the lastest
revision and 's/estimiatedcluases/estimatedclauses/' typo error in the
commit message is not fixed since I have to regenerate all the commits
to fix that. We are still in dicussion stage and I think these impact is
pretty limited on dicussion.

> FYI, I also ran the patch with a $large number of reports without
> observing any errors or crashes.

Good to know that.

> I'll try to look harder at the next patch revision.

Thank you!

--
Best Regards
Andy Fan




В списке pgsql-hackers по дате отправления:

Предыдущее
От: Andy Fan
Дата:
Сообщение: Re: using extended statistics to improve join estimates
Следующее
От: Andy Fan
Дата:
Сообщение: Re: a wrong index choose when statistics is out of date