Re: WIP: collect frequency statistics for arrays

Alexander Korotkov <aekorotkov@gmail.com>

From: Alexander Korotkov <aekorotkov@gmail.com>

To: pgsql-hackers <pgsql-hackers@postgresql.org>

Date: 2011-05-23T17:54:14Z

Lists: pgsql-hackers

Attachments

arrayanalyze-0.2.patch.gz (application/x-gzip) patch

Second version of patch attached. Main changes:
1) ANY and ALL keywords handling.
2) Collecting statistics of array length. It is used in "column <@ const".
3) Relatively accurate estimation of "column <@ const" selectivity. This
estimation is most hard part of patch. I'm warrying that there could be too
expensibe calculations for estimation. Also, likely current comments don't
clearify anything...

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