Re: Statistics and selectivity estimation for ranges

Поиск
Список
Период
Сортировка
От Alexander Korotkov
Тема Re: Statistics and selectivity estimation for ranges
Дата
Msg-id CAPpHfdsPCcCERxywysaYoPUjk3OE6dM9Mm_4Yr86OkAJsSfuHA@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Statistics and selectivity estimation for ranges  (Heikki Linnakangas <heikki.linnakangas@enterprisedb.com>)
Ответы Re: Statistics and selectivity estimation for ranges
Re: Statistics and selectivity estimation for ranges
Re: Statistics and selectivity estimation for ranges
Список pgsql-hackers
On Wed, Aug 15, 2012 at 12:14 PM, Heikki Linnakangas <heikki.linnakangas@enterprisedb.com> wrote:
Histogram of upper bounds would be both more
accurate and natural for some operators. However, it requires collecting
additional statistics while AFAICS it doesn't liberate us from having
histogram of range lengths.

Hmm, if we collected a histogram of lower bounds and a histogram of upper bounds, that would be roughly the same amount of data as for the "standard" histogram with both bounds in the same histogram.

Ok, we've to decide if we need "standard" histogram. In some cases it can be used for more accurate estimation of < and > operators. 
But I think it is not so important. So, we can replace "standard" histogram with histograms of lower and upper bounds?

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

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

Предыдущее
От: Heikki Linnakangas
Дата:
Сообщение: Re: Statistics and selectivity estimation for ranges
Следующее
От: "Etsuro Fujita"
Дата:
Сообщение: Don't allow relative path for copy from file