Proposal: collect frequency statistics for arrays

Поиск
Список
Период
Сортировка
От Alexander Korotkov
Тема Proposal: collect frequency statistics for arrays
Дата
Msg-id AANLkTikiruxOYh6jE_ETK7u4sEW6VXXqFK3Xn0-zVxoe@mail.gmail.com
обсуждение исходный текст
Ответы Re: Proposal: collect frequency statistics for arrays  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-hackers
Hackers,

I have following proposal. Currently the ts_typanalyze function accumulates frequency statistics for ts_vector using lossy counting technique. But no frequency statistics is collecting over arrays. I'm going to generalize ts_typanalyze to make it collecting statistics for arrays too. ts_typanalyze internally uses lexeme comparison and hashing. I'm going to use functions from default btree and hash opclasses of array element type in this capacity. Collected frequency statistics for arrays can be used for && and @> operators selectivity estimation. 

------
With best regards,
Alexander Korotkov.

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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Fix for Index Advisor related hooks
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Proposal: collect frequency statistics for arrays