Re: Progress on fast path sorting, btree index creation time
From:
Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To:
Bruce Momjian <bruce(at)momjian(dot)us>
Cc:
Robert Haas <robertmhaas(at)gmail(dot)com>,
Peter Geoghegan <peter(at)2ndquadrant(dot)com>,
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 16:35:46
Message-ID:
27156.1328718946@sss.pgh.pa.us (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
Bruce Momjian <bruce(at)momjian(dot)us> writes:
> Yes, please. That would be a big help. Is there no optimization for
> strings? I assume they are sorted a lot.
It seems unlikely that it'd be worth including strings, especially if
your locale is not C. This whole thing only makes sense for datatypes
that are comparable in approximately 1 machine instruction.
regards, tom lane
In response to
Responses
pgsql-hackers by date
Next :From: Bruce MomjianDate: 2012-02-08 16:37:23Subject : Re: Progress on fast path sorting, btree index creation
timePrevious :From : Bruce MomjianDate : 2012-02-08 16:22:21Subject : Re: Vacuum rate limit in KBps
