Proposal: collect frequency statistics for arrays - Mailing list pgsql-hackers

From Alexander Korotkov
Subject Proposal: collect frequency statistics for arrays
Date
Msg-id AANLkTikiruxOYh6jE_ETK7u4sEW6VXXqFK3Xn0-zVxoe@mail.gmail.com
Whole thread Raw
Responses Re: Proposal: collect frequency statistics for arrays  (Tom Lane <tgl@sss.pgh.pa.us>)
List 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 by date:

Previous
From: Tom Lane
Date:
Subject: Re: Fix for Index Advisor related hooks
Next
From: Tom Lane
Date:
Subject: Re: Proposal: collect frequency statistics for arrays