From:
Peter Geoghegan <peter(at)2ndquadrant(dot)com>
To:
Robert Haas <robertmhaas(at)gmail(dot)com>
Cc:
Bruce Momjian <bruce(at)momjian(dot)us>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>,
Jay Levitt <jay(dot)levitt(at)gmail(dot)com>,
"Jim Decibel! Nasby" <decibel(at)decibel(dot)org>,
PG Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject:
Re: Progress on fast path sorting, btree index creation time
Date:
2012-02-08 19:50:18
Message-ID:
CAEYLb_WgKh7hBHzGBotKDGpYzDEsyfEcR4=9JMwa2HKEVeBHaw@mail.gmail.com (view raw or flat )
Thread:
2011-12-30 02:03:14 from Peter Geoghegan <peter(at)2ndquadrant(dot)com>
2011-12-30 19:46:24 from Merlin Moncure <mmoncure(at)gmail(dot)com>
2011-12-30 20:30:05 from Peter Geoghegan <peter(at)2ndquadrant(dot)com>
2011-12-30 21:02:36 from Merlin Moncure <mmoncure(at)gmail(dot)com>
2012-01-05 20:23:09 from Robert Haas <robertmhaas(at)gmail(dot)com>
2012-01-05 22:27:28 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2012-01-06 00:01:10 from Peter Geoghegan <peter(at)2ndquadrant(dot)com>
2012-01-06 15:49:14 from Robert Haas <robertmhaas(at)gmail(dot)com>
2012-01-06 17:10:09 from Peter Geoghegan <peter(at)2ndquadrant(dot)com>
2012-01-06 17:29:04 from Robert Haas <robertmhaas(at)gmail(dot)com>
2012-01-06 18:27:31 from Peter Geoghegan <peter(at)2ndquadrant(dot)com>
2012-01-06 18:45:23 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2012-01-06 19:34:03 from Peter Geoghegan <peter(at)2ndquadrant(dot)com>
2012-01-06 21:14:27 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2012-01-06 21:47:30 from Robert Haas <robertmhaas(at)gmail(dot)com>
2012-01-09 19:45:39 from Josh Berkus <josh(at)agliodbs(dot)com>
2012-01-10 06:48:11 from Peter Geoghegan <peter(at)2ndquadrant(dot)com>
2012-01-19 18:47:10 from Peter Geoghegan <peter(at)2ndquadrant(dot)com>
2012-01-21 09:24:07 from Peter Geoghegan <peter(at)2ndquadrant(dot)com>
2012-01-26 19:45:58 from Robert Haas <robertmhaas(at)gmail(dot)com>
2012-01-26 21:09:57 from Peter Geoghegan <peter(at)2ndquadrant(dot)com>
2012-01-26 21:16:53 from Robert Haas <robertmhaas(at)gmail(dot)com>
2012-01-26 22:10:02 from Peter Geoghegan <peter(at)2ndquadrant(dot)com>
2012-01-27 03:32:14 from Robert Haas <robertmhaas(at)gmail(dot)com>
2012-01-27 04:36:19 from Peter Geoghegan <peter(at)2ndquadrant(dot)com>
2012-01-27 13:37:24 from Robert Haas <robertmhaas(at)gmail(dot)com>
2012-01-27 14:27:36 from Peter Geoghegan <peter(at)2ndquadrant(dot)com>
2012-01-27 14:37:37 from Robert Haas <robertmhaas(at)gmail(dot)com>
2012-01-27 20:33:56 from Peter Geoghegan <peter(at)2ndquadrant(dot)com>
2012-01-31 19:47:19 from Robert Haas <robertmhaas(at)gmail(dot)com>
2012-02-01 15:38:05 from Peter Geoghegan <peter(at)2ndquadrant(dot)com>
2012-02-06 21:19:07 from Bruce Momjian <bruce(at)momjian(dot)us>
2012-02-06 21:35:51 from Bruce Momjian <bruce(at)momjian(dot)us>
2012-02-06 21:53:29 from "Jim \"Decibel!\" Nasby" <decibel(at)decibel(dot)org>
2012-02-07 19:39:07 from Jay Levitt <jay(dot)levitt(at)gmail(dot)com>
2012-02-08 02:38:39 from Robert Haas <robertmhaas(at)gmail(dot)com>
2012-02-08 03:10:38 from Bruce Momjian <bruce(at)momjian(dot)us>
2012-02-08 13:33:30 from Peter Geoghegan <peter(at)2ndquadrant(dot)com>
2012-02-08 14:51:05 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2012-02-08 15:17:36 from Robert Haas <robertmhaas(at)gmail(dot)com>
2012-02-08 15:59:02 from Bruce Momjian <bruce(at)momjian(dot)us>
2012-02-08 16:35:46 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2012-02-08 16:37:23 from Bruce Momjian <bruce(at)momjian(dot)us>
2012-02-08 17:58:51 from Robert Haas <robertmhaas(at)gmail(dot)com>
2012-02-08 18:20:19 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2012-02-08 18:48:53 from Peter Geoghegan <peter(at)2ndquadrant(dot)com>
2012-02-08 19:50:18 from Peter Geoghegan <peter(at)2ndquadrant(dot)com>
2012-02-08 23:33:41 from Robert Haas <robertmhaas(at)gmail(dot)com>
2012-02-09 00:54:36 from Peter Geoghegan <peter(at)2ndquadrant(dot)com>
2012-02-08 16:53:37 from Peter Geoghegan <peter(at)2ndquadrant(dot)com>
2012-02-08 15:15:36 from Robert Haas <robertmhaas(at)gmail(dot)com>
2012-02-08 15:57:38 from Bruce Momjian <bruce(at)momjian(dot)us>
2012-02-09 12:24:49 from Noah Misch <noah(at)leadboat(dot)com>
2012-02-09 13:50:22 from Robert Haas <robertmhaas(at)gmail(dot)com>
2012-02-09 14:37:33 from Peter Geoghegan <peter(at)2ndquadrant(dot)com>
2012-02-09 14:51:05 from Robert Haas <robertmhaas(at)gmail(dot)com>
2012-02-09 15:36:23 from Peter Geoghegan <peter(at)2ndquadrant(dot)com>
2012-02-09 17:16:20 from Bruce Momjian <bruce(at)momjian(dot)us>
2012-02-09 17:29:00 from Peter Geoghegan <peter(at)2ndquadrant(dot)com>
2012-02-10 15:30:15 from Peter Geoghegan <peter(at)2ndquadrant(dot)com>
2012-02-15 06:16:47 from Robert Haas <robertmhaas(at)gmail(dot)com>
2012-02-15 13:29:14 from Peter Geoghegan <peter(at)2ndquadrant(dot)com>
2012-02-15 15:27:01 from Robert Haas <robertmhaas(at)gmail(dot)com>
2012-02-16 00:02:48 from Peter Geoghegan <peter(at)2ndquadrant(dot)com>
2012-02-09 14:52:10 from Bruce Momjian <bruce(at)momjian(dot)us>
2012-02-06 22:49:10 from Peter Geoghegan <peter(at)2ndquadrant(dot)com>
2012-02-06 23:43:04 from Bruce Momjian <bruce(at)momjian(dot)us>
2012-02-07 00:21:22 from Bruce Momjian <bruce(at)momjian(dot)us>
2012-02-01 22:12:58 from Jim Nasby <jim(at)nasby(dot)net>
2012-02-02 01:30:18 from Alvaro Herrera <alvherre(at)commandprompt(dot)com>
2012-02-02 14:19:59 from "ktm(at)rice(dot)edu" <ktm(at)rice(dot)edu>
2012-01-08 06:10:06 from Peter Geoghegan <peter(at)2ndquadrant(dot)com>
Lists:
pgsql-hackers
On 8 February 2012 18:48, Peter Geoghegan <peter(at)2ndquadrant(dot)com> wrote:
> I think that there may be additional benefits from making the
> qsort_arg specialisation look less like a c stdlib one, like refining
> the swap logic to have compile-time knowledge of the type it is
> sorting. I'm thinking that we could usefully trim quite a bit from
> this:
It seems like while we cannot get any better performance, no doubt
because the code is already using all manner of optimisations,
including perhaps constant propagation, we can simplify this part of
the code quite a bit. That seems fairly incidental though.
--
Peter Geoghegan http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training and Services
In response to
pgsql-hackers by date
Next :From: Robert HaasDate: 2012-02-08 19:53:36
Subject : Re: Bugs/slowness inserting and indexing cubes
Previous :From : Tom LaneDate : 2012-02-08 19:38:37
Subject : Re: Bugs/slowness inserting and indexing cubes