From:
Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To:
Peter Geoghegan <peter(at)2ndquadrant(dot)com>
Cc:
Robert Haas <robertmhaas(at)gmail(dot)com>, Jay Levitt <jay(dot)levitt(at)gmail(dot)com>,
"Jim \"Decibel!\" Nasby" <decibel(at)decibel(dot)org>,
Bruce Momjian <bruce(at)momjian(dot)us>,
PG Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject:
Re: Progress on fast path sorting, btree index creation time
Date:
2012-02-08 14:51:05
Message-ID:
16818.1328712665@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
Peter Geoghegan <peter(at)2ndquadrant(dot)com> writes:
> It doesn't necessarily matter if we increase the size of the postgres
> binary by 10%, precisely because most of that is not going to be in
> play from one instant to the next.
You've heard of swapping, no? Basically what I'm hearing from you is
total denial that binary bloat costs anything, and that just does not
square with reality. Even if the costs in performance terms are
negligible in many common situations (something that you've asserted
but without offering any proof), there are other costs; software
distribution for instance is definitely sensitive to size. As a Red Hat
person I've had to spend time fighting to keep Postgres included in the
minimum "does it fit on a DVD" distribution of RHEL/Fedora. That case
gets harder to make every year, and yet it's pretty critical to the
success of the project --- if you don't get distributed, you lose users.
IMO this patch is already well past the point of diminishing returns in
value-per-byte-added. I'd like to see it trimmed back to provide a fast
path for just single-column int4/int8/float4/float8 sorts. The other
cases aren't going to offer enough of a win to justify the code space.
regards, tom lane
In response to
Responses
pgsql-hackers by date
Next :From: Robert HaasDate: 2012-02-08 14:56:17Subject : Re: Vacuum rate limit in KBpsPrevious :From : Alvaro HerreraDate : 2012-02-08 14:38:20Subject : Re: Vacuum rate limit in KBps
