Re: [HACKERS] \dt and disk access - Mailing list pgsql-hackers

From David Friend
Subject Re: [HACKERS] \dt and disk access
Date
Msg-id bf036c8e0df38e5f2355aa70ace3abe4
Whole thread Raw
In response to [HACKERS] \dt and disk access  (Bruce Momjian <maillist@candle.pha.pa.us>)
List pgsql-hackers
On Sun, 22 Jun 1997, Thomas G. Lockhart wrote:

> I don't know which Knuth algorithm the code uses, but some sort
> algorithms perform very poorly on data which happens to be already
> sorted. QuickSort, which comes on many Unix boxes (the qsort() call) is
> quickest on completely unordered/disordered data and its slowest
> performance is on already perfectly sorted data (I'm doing this from
> memory, but the facts may be mostly correct :).

from what I remember, the quick sort algorithm works just as fast on
sorted data as on unsorted data.  In other words, the algorithm does not
take advantage of the fact that the data is sorted.

On the other hand, if you go to something like bubble sort, it will
work faster than quick sort if the data is sorted and you are adding one
more item, but on unsorted data it takes an enormously longer length of
time to sort a large list.

David Friend                ! cq995@freenet.carleton.ca
Atlantis Scientific Inc.        ! david.friend@atlsci.com
20 Colonnade Rd, Suite 110        ! 613-727-1087 (voice)
Ottawa, Ontario, CANADA  K2E 7M6    ! 800-265-3894 (voice)
ERGOvista Scientific Image Analysis    ! 613-727-5853 (fax)

------------------------------

pgsql-hackers by date:

Previous
From: Robert Withrow
Date:
Subject: Re: [HACKERS] Array bug is still there....
Next
From: Bruce Momjian
Date:
Subject: Re: [HACKERS] \dt and disk access (fwd)