Re: Selectivity of "=" (Re: [HACKERS] Index not used on simple se lect)

Поиск
Список
Период
Сортировка
От Bruce Momjian
Тема Re: Selectivity of "=" (Re: [HACKERS] Index not used on simple se lect)
Дата
Msg-id 199907290239.WAA27377@candle.pha.pa.us
обсуждение исходный текст
Ответ на Re: Selectivity of "=" (Re: [HACKERS] Index not used on simple se lect)  (Philip Warner <pjw@rhyme.com.au>)
Список pgsql-hackers
> FWIW, statisticians often seem worried about three values: the mean, median
> and mode. I don't really know which is which, but they are:
> 
> o The average of all values
> o The average of the min and max value

We have this value.  Good for > and < comparisons.

> o The most common value.

We know the number of times the most common value occurs, but not the
actual value.

> 
> Someone who knows a lot more about this stuff than me can probably tell us
> how these values will affect the trust we place in the index statistics.
> Someone on this list must be able to give us some insight???
> 
> 
> ----------------------------------------------------------------
> Philip Warner                    |     __---_____
> Albatross Consulting Pty. Ltd.   |----/       -  \
> (A.C.N. 008 659 498)             |          /(@)   ______---_
> Tel: +61-03-5367 7422            |                 _________  \
> Fax: +61-03-5367 7430            |                 ___________ |
> Http://www.rhyme.com.au          |                /           \|
>                                  |    --________--
> PGP key available upon request,  |  /
> and from pgp5.ai.mit.edu:11371   |/
> 


--  Bruce Momjian                        |  http://www.op.net/~candle maillist@candle.pha.pa.us            |  (610)
853-3000+  If your life is a hard drive,     |  830 Blythe Avenue +  Christ can be your backup.        |  Drexel Hill,
Pennsylvania19026
 


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

Предыдущее
От: Philip Warner
Дата:
Сообщение: Re: Selectivity of "=" (Re: [HACKERS] Index not used on simple se lect)
Следующее
От: "Ross J. Reedstrom"
Дата:
Сообщение: Re: [HACKERS] pg_dump not dumping all tables