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
Ответ на
Re: Inlining comparators as a performance optimisation (Peter Geoghegan)
Список
Дерево обсуждения
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 по дате отправления