Re: WIP: collect frequency statistics for arrays

From: Alexander Korotkov <aekorotkov(at)gmail(dot)com>
To: pgsql-hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: WIP: collect frequency statistics for arrays
Date: 2011-05-23 17:54:14
Message-ID: BANLkTi=JXWJehNq3Fd1XDUWm4f79_0r8Sg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

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.

Attachment Content-Type Size
arrayanalyze-0.2.patch.gz application/x-gzip 15.4 KB

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Robert Haas 2011-05-23 18:11:39 Re: Identifying no-op length coercions
Previous Message Tom Lane 2011-05-23 17:53:36 Re: Identifying no-op length coercions