From:
Peter Geoghegan <peter(at)2ndquadrant(dot)com>
To:
Merlin Moncure <mmoncure(at)gmail(dot)com>
Cc:
Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Robert Haas <robertmhaas(at)gmail(dot)com>,
PG Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject:
Re: Progress on fast path sorting, btree index creation time
Date:
2011-12-30 20:30:05
Message-ID:
CAEYLb_VHCbrUbWvKahTrrdRf53+LXvwHYiAg0jQx7Xws94w-zA@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 30 December 2011 19:46, Merlin Moncure <mmoncure(at)gmail(dot)com> wrote:
> On Thu, Dec 29, 2011 at 8:03 PM, Peter Geoghegan <peter(at)2ndquadrant(dot)com> wrote:
>> * A spreadsheet that shows the results of re-running my earlier heap
>> tuple sorting benchmark with this new patch. The improvement in the
>> query that orders by 2 columns is all that is pertinent there, when
>> considering the value of (1) and the sense in standing still for
>> controversy A.
>>
>> * A spreadsheet that shows the difference in index creation times,
>> generated with the help of the new python script.
>
> very nice. let me save everyone the effort of opening his
> spreadsheets (which by the way both show 'HEAD/unoptimized' --
> probably not what you meant): he's showing a consistent ~50% reduction
> in running time of sort driven queries -- that's money.
Sorry, I think you may have misinterpreted the results, which is my
fault - I introduced a formatting error. In the case of the "btree"
spreadsheet, the first query on each sheet should be "create index
test on orderlines (prod_id);", and not "select * from orderlines
order by prod_id". The idea is to compare the results from each set of
binaries across pages of the spreadsheet (note that there are two
tabs). You should not compare anything between the two spreadsheets.
Revised btree results attached. The heap results that I posted do not
have any formatting errors, so they have not been revised.
--
Peter Geoghegan http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training and Services
In response to
Responses
pgsql-hackers by date
Next :From: Merlin MoncureDate: 2011-12-30 21:02:36Subject : Re: Progress on fast path sorting, btree index creation timePrevious :From : Merlin MoncureDate : 2011-12-30 19:46:24Subject : Re: Progress on fast path sorting, btree index creation time
