Re: qsort again (was Re: Strange Create Index

Поиск
Список
Период
Сортировка
Искать
От
Steinar H. Gunderson
Тема
Re: qsort again (was Re: Strange Create Index
Дата
Msg-id
20060216113522.GA3461@uio.no
Ответ на
Список
Дерево обсуждения
Strange Create Index behaviour Gary Doades <gpd@gpdnet.co.uk>
Re: Strange Create Index behaviour Simon Riggs <simon@2ndquadrant.com>
Re: Strange Create Index behaviour Tom Lane <tgl@sss.pgh.pa.us>
Re: Strange Create Index behaviour Simon Riggs <simon@2ndquadrant.com>
Re: Strange Create Index behaviour Tom Lane <tgl@sss.pgh.pa.us>
Re: Strange Create Index behaviour Tom Lane <tgl@sss.pgh.pa.us>
Re: Strange Create Index behaviour Gary Doades <gpd@gpdnet.co.uk>
Re: Strange Create Index behaviour Tom Lane <tgl@sss.pgh.pa.us>
Re: Strange Create Index behaviour Simon Riggs <simon@2ndquadrant.com>
qsort again (was Re: Strange Create Index behaviour) Tom Lane <tgl@sss.pgh.pa.us>
Re: [HACKERS] qsort again (was Re: Strange Create Index Neil Conway <neilc@samurai.com>
Re: [HACKERS] qsort again Florian Weimer <fw@deneb.enyo.de>
Re: [HACKERS] qsort again Martijn van Oosterhout <kleptog@svana.org>
Re: [HACKERS] qsort again Sven Geisler <sgeisler@aeccom.com>
Re: [HACKERS] qsort again Ron <rjpeace@earthlink.net>
Re: qsort again (was Re: Strange Create Index behaviour) Tom Lane <tgl@sss.pgh.pa.us>
Poor performance o "Craig A. James" <cjames@modgraph-usa.com>
Re: Poor performance o Tom Lane <tgl@sss.pgh.pa.us>
Re: Poor performance o "Craig A. James" <cjames@modgraph-usa.com>
Re: Poor performance o Tom Lane <tgl@sss.pgh.pa.us>
Re: Poor performance o "Jim C. Nasby" <jnasby@pervasive.com>
Re: qsort again (was Re: Strange Create Index behaviour) Gary Doades <gpd@gpdnet.co.uk>
Re: qsort again (was Re: Strange Create Index behaviour) Tom Lane <tgl@sss.pgh.pa.us>
Re: [HACKERS] qsort again (was Re: Strange Create Index behaviour) Tom Lane <tgl@sss.pgh.pa.us>
Re: [HACKERS] qsort again (was Re: Strange Create Index behaviour) Tom Lane <tgl@sss.pgh.pa.us>
Re: [HACKERS] qsort again (was Re: Strange Create Index Simon Riggs <simon@2ndquadrant.com>
Re: [HACKERS] qsort again (was Re: Strange Create Index "Gary Doades" <gpd@gpdnet.co.uk>
Re: [HACKERS] qsort again (was Re: Strange Create Index behaviour) Tom Lane <tgl@sss.pgh.pa.us>
Re: [HACKERS] qsort again (was Re: Strange Create Index "Gary Doades" <gpd@gpdnet.co.uk>
Re: qsort again (was Re: Strange Create Index behaviour) Christopher Kings-Lynne <chriskl@familyhealth.com.au>
Re: qsort again (was Re: Strange Create Index Ron <rjpeace@earthlink.net>
Re: qsort again (was Re: Strange Create Index behaviour) Tom Lane <tgl@sss.pgh.pa.us>
Re: qsort again (was Re: Strange Create Index Ron <rjpeace@earthlink.net>
Re: qsort again (was Re: Strange Create Index "Steinar H. Gunderson" <sgunderson@bigfoot.com>
Re: qsort again (was Re: Strange Create Index Neil Conway <neilc@samurai.com>
Re: qsort again (was Re: Strange Create Index Ron <rjpeace@earthlink.net>
Re: [HACKERS] qsort again (was Re: Strange Create Index Martijn van Oosterhout <kleptog@svana.org>
Re: [HACKERS] qsort again (was Re: Strange Create Ron <rjpeace@earthlink.net>
Re: [HACKERS] qsort again (was Re: Strange Create Tom Lane <tgl@sss.pgh.pa.us>
Re: [HACKERS] qsort again (was Re: Strange Create Ron <rjpeace@earthlink.net>
Re: [HACKERS] qsort again (was Re: Strange Create Martijn van Oosterhout <kleptog@svana.org>
Re: [HACKERS] qsort again (was Re: Strange Create Scott Lamb <slamb@slamb.org>
Re: [HACKERS] qsort again (was Re: Strange Create Ron <rjpeace@earthlink.net>
Re: [HACKERS] qsort again (was Re: Strange Create Ron <rjpeace@earthlink.net>
Re: [HACKERS] qsort again (was Re: Strange Create Ragnar <gnari@hive.is>
Re: [HACKERS] qsort again (was Re: Strange Create Ron <rjpeace@earthlink.net>
Re: [HACKERS] qsort again (was Re: Strange Create Ragnar <gnari@hive.is>
Re: [HACKERS] qsort again (was Re: Strange Create "Gregory Maxwell" <gmaxwell@gmail.com>
Re: [HACKERS] qsort again (was Re: Strange Create Markus Schaber <schabi@logix-tt.com>
Re: [HACKERS] qsort again (was Re: Strange Create Ron <rjpeace@earthlink.net>
Re: [HACKERS] qsort again (was Re: Strange Create Martijn van Oosterhout <kleptog@svana.org>
Re: [HACKERS] qsort again (was Re: Strange Create Ron <rjpeace@earthlink.net>
Re: [HACKERS] qsort again (was Re: Strange Create PFC <lists@peufeu.com>
Re: qsort again (was Re: Strange Create Index Markus Schaber <schabi@logix-tt.com>
Re: [HACKERS] qsort again (was Re: Strange Create Index "Jonah H. Harris" <jonah.harris@gmail.com>
Re: qsort again (was Re: Strange Create Index "Craig A. James" <cjames@modgraph-usa.com>
Re: [HACKERS] qsort again (was Re: Strange Create Index Tom Lane <tgl@sss.pgh.pa.us>
Re: [HACKERS] qsort again (was Re: Strange Create Index Mark Lewis <mark.lewis@mir3.com>
Re: [HACKERS] qsort again (was Re: Strange Create Index Martijn van Oosterhout <kleptog@svana.org>
Re: [HACKERS] qsort again (was Re: Strange Create Index Markus Schaber <schabi@logix-tt.com>
Re: [HACKERS] qsort again (was Re: Strange Create Index Greg Stark <gsstark@mit.edu>
Re: [HACKERS] qsort again (was Re: Strange Create Index Mark Lewis <mark.lewis@mir3.com>
Re: [HACKERS] qsort again (was Re: Strange Create Index David Lang <dlang@invendra.net>
Re: [HACKERS] qsort again (was Re: Strange Create Index Mark Lewis <mark.lewis@mir3.com>
Re: [HACKERS] qsort again (was Re: Strange Create Index Tom Lane <tgl@sss.pgh.pa.us>
Re: [HACKERS] qsort again (was Re: Strange Create Index Markus Schaber <schabi@logix-tt.com>
Re: [HACKERS] qsort again (was Re: Strange Create Index Scott Lamb <slamb@slamb.org>
Re: [HACKERS] qsort again (was Re: Strange Create Index Martijn van Oosterhout <kleptog@svana.org>
Re: [HACKERS] qsort again (was Re: Strange Create Index PFC <lists@peufeu.com>
Re: [HACKERS] qsort again (was Re: Strange Create Index "Steinar H. Gunderson" <sgunderson@bigfoot.com>
Re: [HACKERS] qsort again (was Re: Strange Create Index Markus Schaber <schabi@logix-tt.com>
Re: Strange Create Index behaviour Gary Doades <gpd@gpdnet.co.uk>
Re: Strange Create Index behaviour Gary Doades <gpd@gpdnet.co.uk>
Re: Strange Create Index behaviour Gary Doades <gpd@gpdnet.co.uk>
On Wed, Feb 15, 2006 at 11:30:54PM -0500, Ron wrote:
> Even better (and more easily scaled as the number of GPR's in the CPU 
> changes) is to use
> the set {L; L+1; L+2; t>>1; R-2; R-1; R}
> This means that instead of 7 random memory accesses, we have 3; two 
> of which result in a
> burst access for three elements each.

Isn't that improvement going to disappear competely if you choose a bad
pivot?

> SIDE NOTE: IIRC glibc's qsort is actually merge sort.  Merge sort 
> performance is insensitive to all inputs, and there are way to 
> optimize it as well.

glibc-2.3.5/stdlib/qsort.c:

  /* Order size using quicksort.  This implementation incorporates
     four optimizations discussed in Sedgewick:

I can't see any references to merge sort in there at all.

/* Steinar */
-- 
Homepage: http://www.sesse.net/
В списке pgsql-performance по дате отправления
От: Gary Doades
Дата:
От: Florian Weimer
Дата:
Сообщение: Re: [HACKERS] qsort again
FAQ