Re: Inlining comparators as a performance optimisation

Поиск
Список
Период
Сортировка
Искать
От
Robert Haas
Тема
Re: Inlining comparators as a performance optimisation
Дата
Msg-id
CA+TgmoZsvcNZpw61-eA0PHTwWAN3erm_Rza25ubC2OMU+3hvCg@mail.gmail.com
Ответ на
Список
Дерево обсуждения
Inlining comparators as a performance optimisation Peter Geoghegan <peter@2ndquadrant.com>
Re: Inlining comparators as a performance optimisation Tom Lane <tgl@sss.pgh.pa.us>
Re: Inlining comparators as a performance optimisation Simon Riggs <simon@2ndQuadrant.com>
Re: Inlining comparators as a performance optimisation Peter Geoghegan <peter@2ndquadrant.com>
[PATCH] POC: inline int4 comparison in tuplesort Dan McGee <dan@archlinux.org>
Re: Inlining comparators as a performance optimisation Heikki Linnakangas <heikki.linnakangas@enterprisedb.com>
Re: Inlining comparators as a performance optimisation Simon Riggs <simon@2ndQuadrant.com>
Re: Inlining comparators as a performance optimisation Tom Lane <tgl@sss.pgh.pa.us>
Re: Inlining comparators as a performance optimisation Simon Riggs <simon@2ndQuadrant.com>
Re: Inlining comparators as a performance optimisation Heikki Linnakangas <heikki.linnakangas@enterprisedb.com>
Re: Inlining comparators as a performance optimisation Greg Stark <stark@mit.edu>
Re: Inlining comparators as a performance optimisation Robert Haas <robertmhaas@gmail.com>
Re: Inlining comparators as a performance optimisation Peter Geoghegan <peter@2ndquadrant.com>
Re: Inlining comparators as a performance optimisation Heikki Linnakangas <heikki.linnakangas@enterprisedb.com>
Re: Inlining comparators as a performance optimisation Tom Lane <tgl@sss.pgh.pa.us>
Re: Inlining comparators as a performance optimisation Andrew Dunstan <andrew@dunslane.net>
Re: Inlining comparators as a performance optimisation Tom Lane <tgl@sss.pgh.pa.us>
Re: Inlining comparators as a performance optimisation Heikki Linnakangas <heikki.linnakangas@enterprisedb.com>
Re: Inlining comparators as a performance optimisation Tom Lane <tgl@sss.pgh.pa.us>
Re: Inlining comparators as a performance optimisation "Pierre C" <lists@peufeu.com>
Re: Inlining comparators as a performance optimisation Bruce Momjian <bruce@momjian.us>
Re: Inlining comparators as a performance optimisation Heikki Linnakangas <heikki.linnakangas@enterprisedb.com>
Re: Inlining comparators as a performance optimisation Tom Lane <tgl@sss.pgh.pa.us>
Re: Inlining comparators as a performance optimisation Greg Stark <stark@mit.edu>
Re: Inlining comparators as a performance optimisation Tom Lane <tgl@sss.pgh.pa.us>
Re: Inlining comparators as a performance optimisation Peter Geoghegan <peter@2ndquadrant.com>
Re: Inlining comparators as a performance optimisation Bruce Momjian <bruce@momjian.us>
Re: Inlining comparators as a performance optimisation Greg Stark <stark@mit.edu>
Re: Inlining comparators as a performance optimisation Robert Haas <robertmhaas@gmail.com>
Re: Inlining comparators as a performance optimisation Bruce Momjian <bruce@momjian.us>
Re: Inlining comparators as a performance optimisation Robert Haas <robertmhaas@gmail.com>
Re: Inlining comparators as a performance optimisation Peter Geoghegan <peter@2ndquadrant.com>
Re: Inlining comparators as a performance optimisation Robert Haas <robertmhaas@gmail.com>
Re: Inlining comparators as a performance optimisation Martijn van Oosterhout <kleptog@svana.org>
Re: Inlining comparators as a performance optimisation Simon Riggs <simon@2ndQuadrant.com>
Re: Inlining comparators as a performance optimisation Tom Lane <tgl@sss.pgh.pa.us>
Re: Inlining comparators as a performance optimisation Simon Riggs <simon@2ndQuadrant.com>
Re: Inlining comparators as a performance optimisation Robert Haas <robertmhaas@gmail.com>
Re: Inlining comparators as a performance optimisation Peter Geoghegan <peter@2ndquadrant.com>
Re: Inlining comparators as a performance optimisation Robert Haas <robertmhaas@gmail.com>
Re: Inlining comparators as a performance optimisation Peter Geoghegan <peter@2ndquadrant.com>
Re: Inlining comparators as a performance optimisation Peter Geoghegan <peter@2ndquadrant.com>
Re: Inlining comparators as a performance optimisation Peter Geoghegan <peter@2ndquadrant.com>
Re: Inlining comparators as a performance optimisation Greg Stark <stark@mit.edu>
Re: Inlining comparators as a performance optimisation Peter Geoghegan <peter@2ndquadrant.com>
Re: Inlining comparators as a performance optimisation Robert Haas <robertmhaas@gmail.com>
Re: Inlining comparators as a performance optimisation Peter Geoghegan <peter@2ndquadrant.com>
Re: Inlining comparators as a performance optimisation Robert Haas <robertmhaas@gmail.com>
Re: Inlining comparators as a performance optimisation Peter Geoghegan <peter@2ndquadrant.com>
Re: Inlining comparators as a performance optimisation Peter Geoghegan <peter@2ndquadrant.com>
Re: Inlining comparators as a performance optimisation Peter Geoghegan <peter@2ndquadrant.com>
Re: Inlining comparators as a performance optimisation Bruce Momjian <bruce@momjian.us>
Re: Inlining comparators as a performance optimisation Peter Geoghegan <peter@2ndquadrant.com>
Re: Inlining comparators as a performance optimisation Bruce Momjian <bruce@momjian.us>
Re: Inlining comparators as a performance optimisation Andres Freund <andres@anarazel.de>
Re: Inlining comparators as a performance optimisation Greg Jaskiewicz <gj@pointblue.com.pl>
Re: Inlining comparators as a performance optimisation Peter Geoghegan <peter@2ndquadrant.com>
Re: Inlining comparators as a performance optimisation Robert Haas <robertmhaas@gmail.com>
Re: Inlining comparators as a performance optimisation Tom Lane <tgl@sss.pgh.pa.us>
Re: Inlining comparators as a performance optimisation Robert Haas <robertmhaas@gmail.com>
Re: Inlining comparators as a performance optimisation Tom Lane <tgl@sss.pgh.pa.us>
Re: Inlining comparators as a performance optimisation Robert Haas <robertmhaas@gmail.com>
Re: Inlining comparators as a performance optimisation Tom Lane <tgl@sss.pgh.pa.us>
Re: Inlining comparators as a performance optimisation Robert Haas <robertmhaas@gmail.com>
Re: Inlining comparators as a performance optimisation Tom Lane <tgl@sss.pgh.pa.us>
Re: Inlining comparators as a performance optimisation Robert Haas <robertmhaas@gmail.com>
Re: Inlining comparators as a performance optimisation Tom Lane <tgl@sss.pgh.pa.us>
Re: Inlining comparators as a performance optimisation Bruce Momjian <bruce@momjian.us>
Re: Inlining comparators as a performance optimisation Robert Haas <robertmhaas@gmail.com>
Re: Inlining comparators as a performance optimisation Tom Lane <tgl@sss.pgh.pa.us>
Re: Inlining comparators as a performance optimisation Bruce Momjian <bruce@momjian.us>
Re: Inlining comparators as a performance optimisation Tom Lane <tgl@sss.pgh.pa.us>
Re: Inlining comparators as a performance optimisation Robert Haas <robertmhaas@gmail.com>
Re: Inlining comparators as a performance optimisation Tom Lane <tgl@sss.pgh.pa.us>
Re: Inlining comparators as a performance optimisation Robert Haas <robertmhaas@gmail.com>
Re: Inlining comparators as a performance optimisation Tom Lane <tgl@sss.pgh.pa.us>
Re: Inlining comparators as a performance optimisation Robert Haas <robertmhaas@gmail.com>
Re: Inlining comparators as a performance optimisation Tom Lane <tgl@sss.pgh.pa.us>
Re: Inlining comparators as a performance optimisation Robert Haas <robertmhaas@gmail.com>
Re: Inlining comparators as a performance optimisation Tom Lane <tgl@sss.pgh.pa.us>
Re: Inlining comparators as a performance optimisation Robert Haas <robertmhaas@gmail.com>
Re: Inlining comparators as a performance optimisation Tom Lane <tgl@sss.pgh.pa.us>
Re: Inlining comparators as a performance optimisation Robert Haas <robertmhaas@gmail.com>
Re: Inlining comparators as a performance optimisation Peter Geoghegan <peter@2ndquadrant.com>
Re: Inlining comparators as a performance optimisation Robert Haas <robertmhaas@gmail.com>
Re: Inlining comparators as a performance optimisation Greg Smith <greg@2ndQuadrant.com>
Re: Inlining comparators as a performance optimisation Peter Geoghegan <peter@2ndquadrant.com>
Re: Inlining comparators as a performance optimisation Robert Haas <robertmhaas@gmail.com>
Re: Inlining comparators as a performance optimisation Peter Geoghegan <peter@2ndquadrant.com>
Re: Inlining comparators as a performance optimisation Peter Geoghegan <peter@2ndquadrant.com>
Re: Inlining comparators as a performance optimisation Heikki Linnakangas <heikki.linnakangas@enterprisedb.com>
Re: Inlining comparators as a performance optimisation Peter Geoghegan <peter@2ndquadrant.com>
Re: Inlining comparators as a performance optimisation Tom Lane <tgl@sss.pgh.pa.us>
Re: Inlining comparators as a performance optimisation Nicolas Barbier <nicolas.barbier@gmail.com>
Re: Inlining comparators as a performance optimisation Pavel Stehule <pavel.stehule@gmail.com>
Re: Inlining comparators as a performance optimisation Peter Geoghegan <peter@2ndquadrant.com>
Re: Inlining comparators as a performance optimisation Peter Geoghegan <peter@2ndquadrant.com>
Re: Inlining comparators as a performance optimisation Robert Haas <robertmhaas@gmail.com>
Re: Inlining comparators as a performance optimisation Amit Kapila <amit.kapila@huawei.com>
On Tue, Sep 20, 2011 at 7:53 PM, Peter Geoghegan  wrote:
> I don't think that the fact that that happens is at all significant at
> this early stage, and it never even occurred to me that you'd think
> that it might be. I was simply disclosing a quirk of this POC patch.
> The workaround is probably to use a macro instead. For the benefit of
> those that didn't follow the other threads, the macro-based qsort
> implementation, which I found to perform significantly better than
> regular qsort(), runs like this on my laptop when I built at 02 with
> GCC 4.6 just now:
>
> C stdlib quick-sort time elapsed: 2.092451 seconds
> Inline quick-sort time elapsed: 1.587651 seconds

Results on my machine, for what they're worth:

[rhaas inline_compar_test]$ gcc -O0 qsort-inline-benchmark.c
[rhaas inline_compar_test]$ ./a.out
C stdlib quick-sort time elapsed: 2.366762 seconds
Inline quick-sort time elapsed: 1.807951 seconds
[rhaas inline_compar_test]$ gcc -O1 qsort-inline-benchmark.c
[rhaas inline_compar_test]$ ./a.out
C stdlib quick-sort time elapsed: 1.970473 seconds
Inline quick-sort time elapsed: 1.002765 seconds
[rhaas inline_compar_test]$ gcc -O2 qsort-inline-benchmark.c
[rhaas inline_compar_test]$ ./a.out
C stdlib quick-sort time elapsed: 1.966408 seconds
Inline quick-sort time elapsed: 0.958999 seconds
[rhaas inline_compar_test]$ gcc -O3 qsort-inline-benchmark.c
[rhaas inline_compar_test]$ ./a.out
C stdlib quick-sort time elapsed: 1.988693 seconds
Inline quick-sort time elapsed: 0.975090 seconds

-- 
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company

В списке pgsql-hackers по дате отправления
От: Alvaro Herrera
Дата:
От: Alvaro Herrera
Дата:
FAQ