Re: [HACKERS] qsort again (was Re: Strange Create

Поиск
Список
Период
Сортировка
От Ron
Тема Re: [HACKERS] qsort again (was Re: Strange Create
Дата
Msg-id 7.0.1.0.2.20060218112647.0397ce48@earthlink.net
обсуждение исходный текст
Ответ на Re: [HACKERS] qsort again (was Re: Strange Create Index behaviour)  ("Dann Corbit" <DCorbit@connx.com>)
Список pgsql-performance
At 08:37 PM 2/15/2006, Dann Corbit wrote:

>Adding some randomness to the selection of the pivot is a known
>technique to fix the oddball partitions problem.

True, but it makes QuickSort slower than say MergeSort because of the
expense of the PRNG being called ~O(lgN) times during a sort.


>However, Bentley and Sedgewick proved that every quick sort
>algorithm has some input set that makes it go quadratic

Yep.  OTOH, that input set can be so specific and so unusual as to
require astronomically unlikely bad luck or hostile hacking in order
for it to actually occur.


>  (hence the recent popularity of introspective sort, which switches
> to heapsort if quadratic behavior is detected.  The C++ template I
> submitted was an example of introspective sort, but PostgreSQL does
> not use C++ so it was not helpful).
...and there are other QuickSort+Other hybrids that address the issue
as well.  MergeSort, RadixExchangeSort, and BucketSort all come to
mind.  See Gonnet and Baeza-Yates, etc.


>Here are some cases known to make qsort go quadratic:
>1. Data already sorted

Only if one element is used to choose the pivot; _and_ only if the
pivot is the first or last element of each pass.
Even just always using the middle element as the pivot avoids this
problem.  See Sedgewick or Knuth.


>2. Data reverse sorted

Ditto above.


>3. Data organ-pipe sorted or ramp

Not sure what this means?  Regardless, median of n partitioning that
includes samples from each of the 1st 1/3, 2nd 1/3, and final 3rd of
the data is usually enough to guarantee O(NlgN) behavior unless the
_specific_ distribution known to be pessimal to that sampling
algorithm is encountered.  The only times I've ever seen it ITRW was
as a result of hostile activity: purposely arranging the data in such
a manner is essentially a DoS attack.


>4. Almost all data of the same value

Well known fixes to inner loop available to avoid this problem.


>There are probably other cases.  Randomizing the pivot helps some,
>as does check for in-order or reverse order partitions.
Randomizing the choice of pivot essentially guarantees O(NlgN)
behavior no matter what the distribution of the data at the price of
increasing the cost of each pass by a constant factor (the generation
of a random number or numbers).


In sum, QuickSort gets all sorts of bad press that is far more FUD
than fact ITRW.
Ron.



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

Предыдущее
От: Fredrik Olsson
Дата:
Сообщение: Force another plan.
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Force another plan.