From:
Alvaro Herrera <alvherre(at)commandprompt(dot)com>
To:
Jim Nasby <jim(at)nasby(dot)net>
Cc:
Robert Haas <robertmhaas(at)gmail(dot)com>, Peter Geoghegan <peter(at)2ndquadrant(dot)com>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Pg Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject:
Re: Progress on fast path sorting, btree index creation time
Date:
2012-02-02 01:30:18
Message-ID:
1328146187-sup-3553@alvh.no-ip.org (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
Excerpts from Jim Nasby's message of mié feb 01 19:12:58 -0300 2012:
> On Jan 26, 2012, at 9:32 PM, Robert Haas wrote:
> > But if we want to put it on a diet, the first thing I'd probably be
> > inclined to lose is the float4 specialization. Some members of the
> > audience will recall that I take dim view of floating point arithmetic
> > generally, but I'll concede that there are valid reasons for using
> > float8. I have a harder time coming up with a good reason to use
> > float4 - ever, for anything you care about. So I would be inclined to
> > think that if we want to trim this back a bit, maybe that's the one to
> > let go. If we want to be even more aggressive, the next thing I'd
> > probably lose is the optimization of multiple sortkey cases, on the
> > theory that single sort keys are probably by far the most common
> > practical case.
>
> I do find float4 to be useful, though it's possible that my understanding is flawed…
>
> We end up using float to represent ratios in our database; things that really, honest to God do NOT need to be exact.
But then, do you sort using those ratios?
--
Álvaro Herrera <alvherre(at)commandprompt(dot)com>
The PostgreSQL Company - Command Prompt, Inc.
PostgreSQL Replication, Consulting, Custom Development, 24x7 support
In response to
pgsql-hackers by date
Next :From: Robert HaasDate: 2012-02-02 01:40:40Subject : Re: Index-only scan performance regressionPrevious :From : Alvaro HerreraDate : 2012-02-02 01:07:55Subject : Re: feature request - datum_compute_size and datum write_should be public
