Re: sortsupport for text

Поиск
Список
Период
Сортировка
Искать
От
Florian Pflug
Тема
Re: sortsupport for text
Дата
Msg-id
2CF4AD23-269D-45CA-B850-4E6ED3090537@phlo.org
Ответ на
Re: sortsupport for text (Peter Geoghegan)
Список
Дерево обсуждения
sortsupport for text Robert Haas <robertmhaas@gmail.com>
Re: sortsupport for text Noah Misch <noah@leadboat.com>
Re: sortsupport for text "Kevin Grittner" <Kevin.Grittner@wicourts.gov>
Re: sortsupport for text Peter Geoghegan <peter@2ndquadrant.com>
Re: sortsupport for text Robert Haas <robertmhaas@gmail.com>
Re: sortsupport for text Peter Geoghegan <peter@2ndquadrant.com>
Re: sortsupport for text Tom Lane <tgl@sss.pgh.pa.us>
Re: sortsupport for text Robert Haas <robertmhaas@gmail.com>
Re: sortsupport for text Tom Lane <tgl@sss.pgh.pa.us>
Re: sortsupport for text Robert Haas <robertmhaas@gmail.com>
Re: sortsupport for text Tom Lane <tgl@sss.pgh.pa.us>
Re: sortsupport for text Robert Haas <robertmhaas@gmail.com>
Re: sortsupport for text Peter Geoghegan <peter@2ndquadrant.com>
Re: sortsupport for text Robert Haas <robertmhaas@gmail.com>
Re: sortsupport for text Peter Geoghegan <peter@2ndquadrant.com>
Re: sortsupport for text Robert Haas <robertmhaas@gmail.com>
Re: sortsupport for text Peter Geoghegan <peter@2ndquadrant.com>
Re: sortsupport for text Robert Haas <robertmhaas@gmail.com>
Re: sortsupport for text Peter Geoghegan <peter@2ndquadrant.com>
Re: sortsupport for text Robert Haas <robertmhaas@gmail.com>
Re: sortsupport for text Peter Geoghegan <peter@2ndquadrant.com>
Re: sortsupport for text Dimitri Fontaine <dimitri@2ndQuadrant.fr>
Re: sortsupport for text Peter Geoghegan <peter@2ndquadrant.com>
Re: sortsupport for text Robert Haas <robertmhaas@gmail.com>
Re: sortsupport for text Peter Geoghegan <peter@2ndquadrant.com>
Re: sortsupport for text Robert Haas <robertmhaas@gmail.com>
Re: sortsupport for text Greg Stark <stark@mit.edu>
Re: sortsupport for text Tom Lane <tgl@sss.pgh.pa.us>
Re: sortsupport for text Robert Haas <robertmhaas@gmail.com>
Re: sortsupport for text Peter Geoghegan <peter@2ndquadrant.com>
Re: sortsupport for text Peter Geoghegan <peter@2ndquadrant.com>
Re: sortsupport for text Tom Lane <tgl@sss.pgh.pa.us>
Re: sortsupport for text Peter Geoghegan <peter@2ndquadrant.com>
Re: sortsupport for text Tom Lane <tgl@sss.pgh.pa.us>
Re: sortsupport for text Peter Geoghegan <peter@2ndquadrant.com>
Re: sortsupport for text Robert Haas <robertmhaas@gmail.com>
Re: sortsupport for text Peter Geoghegan <peter@2ndquadrant.com>
Re: sortsupport for text Robert Haas <robertmhaas@gmail.com>
Re: sortsupport for text Robert Haas <robertmhaas@gmail.com>
Re: sortsupport for text Martijn van Oosterhout <kleptog@svana.org>
Re: sortsupport for text Greg Stark <stark@mit.edu>
On Jun21, 2012, at 02:22 , Peter Geoghegan wrote:
> I've written a very small C++ program, which I've attached, that
> basically proves that this can still make a fairly large difference -
> I hope it's okay that that it's C++, but that allowed me to write the
> program quickly, with no dependencies for anyone who cares to try this
> out, other than a C++ compiler and the standard library.

Uh, are you sure the results aren't swapped? string_wrapper takes a
parameter called use_strcoll, and it indeed uses strcoll() if that
parameter is true, and strxfm() otherwise. But then it passes *false*
to determine the speed of strcoll(), and *true* to determine the speed
of strxfm()...

Also, place_random_string() needs to insert a terminating zero byte,
otherwise set_test segfaults, at least on my OSX machine.

best regards,
Florian Pflug


В списке pgsql-hackers по дате отправления
От: Amit Kapila
Дата:
От: Peter Geoghegan
Дата:
Сообщение: Re: sortsupport for text
FAQ