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

From Bruce Momjian
Subject Re: [HACKERS] \dt and disk access
Date
Msg-id e5898047ff19390346031fc6df90cf11
Whole thread Raw
In response to [HACKERS] \dt and disk access  (Bruce Momjian <maillist@candle.pha.pa.us>)
List pgsql-hackers
> >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.
>

One thing I am going to look into is replacing the btree-build in the
current psort with a qsort of HeapTuple pointers.

- --
Bruce Momjian
maillist@candle.pha.pa.us

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

End of hackers-digest V1 #398
*****************************

pgsql-hackers by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: [HACKERS] \dt and disk access (fwd)
Next
From: David Friend
Date:
Subject: Re: [HACKERS] problems with sunos4 port, endian?