From:
Andres Freund <andres(at)anarazel(dot)de>
To:
Robert Haas <robertmhaas(at)gmail(dot)com>
Cc:
Jeff Janes <jeff(dot)janes(at)gmail(dot)com>,
Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>,
Bruce Momjian <bruce(at)momjian(dot)us>,
pgsql-hackers(at)postgresql(dot)org,
Heikki Linnakangas <heikki(dot)linnakangas(at)enterprisedb(dot)com>
Subject:
Re: profiling connection overhead
Date:
2010-12-01 14:24:07
Message-ID:
201012011524.08672.andres@anarazel.de (view raw or flat )
Thread:
2010-11-24 05:07:27 from Robert Haas <robertmhaas(at)gmail(dot)com>
2010-11-24 05:08:37 from Robert Haas <robertmhaas(at)gmail(dot)com>
2010-11-24 07:10:37 from Heikki Linnakangas <heikki(dot)linnakangas(at)enterprisedb(dot)com>
2010-11-24 12:02:53 from Robert Haas <robertmhaas(at)gmail(dot)com>
2010-11-24 15:25:42 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2010-11-24 16:20:38 from Robert Haas <robertmhaas(at)gmail(dot)com>
2010-11-24 16:33:47 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2010-11-24 18:01:32 from Robert Haas <robertmhaas(at)gmail(dot)com>
2010-11-24 18:06:58 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2010-11-24 18:20:36 from Robert Haas <robertmhaas(at)gmail(dot)com>
2010-11-24 18:47:13 from Gerhard Heift <ml-postgresql-20081012-3518(at)gheift(dot)de>
2010-11-24 19:59:27 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2010-11-24 19:30:47 from Robert Haas <robertmhaas(at)gmail(dot)com>
2010-11-24 20:14:22 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2010-11-24 20:47:32 from Robert Haas <robertmhaas(at)gmail(dot)com>
2010-11-24 20:53:20 from Andres Freund <andres(at)anarazel(dot)de>
2010-11-24 20:54:53 from Robert Haas <robertmhaas(at)gmail(dot)com>
2010-11-24 21:05:13 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2010-11-24 21:56:47 from Robert Haas <robertmhaas(at)gmail(dot)com>
2010-11-24 22:03:48 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2010-11-24 22:15:13 from Andres Freund <andres(at)anarazel(dot)de>
2010-11-24 22:30:49 from Robert Haas <robertmhaas(at)gmail(dot)com>
2010-11-24 22:42:58 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2010-11-24 22:44:20 from Robert Haas <robertmhaas(at)gmail(dot)com>
2010-11-24 21:05:48 from Andres Freund <andres(at)anarazel(dot)de>
2010-11-24 21:18:08 from Robert Haas <robertmhaas(at)gmail(dot)com>
2010-11-24 21:25:45 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2010-11-24 21:30:07 from Andres Freund <andres(at)anarazel(dot)de>
2010-11-24 21:28:43 from Andres Freund <andres(at)anarazel(dot)de>
2010-11-28 04:18:58 from Bruce Momjian <bruce(at)momjian(dot)us>
2010-11-28 05:01:59 from Robert Haas <robertmhaas(at)gmail(dot)com>
2010-11-28 16:41:46 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2010-11-28 19:38:07 from Robert Haas <robertmhaas(at)gmail(dot)com>
2010-11-28 20:53:00 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2010-11-28 23:23:09 from Robert Haas <robertmhaas(at)gmail(dot)com>
2010-11-28 23:41:58 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2010-11-29 00:08:10 from Robert Haas <robertmhaas(at)gmail(dot)com>
2010-11-29 00:33:01 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2010-11-29 00:52:09 from Greg Stark <gsstark(at)mit(dot)edu>
2010-11-29 01:01:35 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2010-11-30 03:35:52 from Bruce Momjian <bruce(at)momjian(dot)us>
2010-11-30 01:28:56 from Bruce Momjian <bruce(at)momjian(dot)us>
2010-11-29 10:04:03 from Dimitri Fontaine <dimitri(at)2ndQuadrant(dot)fr>
2010-11-29 00:15:43 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2010-11-29 01:34:09 from Robert Haas <robertmhaas(at)gmail(dot)com>
2010-11-29 04:51:43 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2010-11-29 16:57:51 from Robert Haas <robertmhaas(at)gmail(dot)com>
2010-11-29 17:24:54 from Andres Freund <andres(at)anarazel(dot)de>
2010-11-29 17:34:02 from Robert Haas <robertmhaas(at)gmail(dot)com>
2010-11-29 17:49:12 from Andres Freund <andres(at)anarazel(dot)de>
2010-11-29 17:50:08 from Jeff Janes <jeff(dot)janes(at)gmail(dot)com>
2010-11-29 18:10:07 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2010-11-30 07:21:29 from Andres Freund <andres(at)anarazel(dot)de>
2010-11-30 19:37:13 from Peter Eisentraut <peter_e(at)gmx(dot)net>
2010-11-30 20:49:07 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2010-12-01 05:14:56 from Peter Eisentraut <peter_e(at)gmx(dot)net>
2010-11-29 17:50:12 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2010-11-29 18:10:45 from Robert Haas <robertmhaas(at)gmail(dot)com>
2010-11-30 01:34:06 from Bruce Momjian <bruce(at)momjian(dot)us>
2010-11-30 01:13:26 from Bruce Momjian <bruce(at)momjian(dot)us>
2010-12-01 04:32:23 from Jeff Janes <jeff(dot)janes(at)gmail(dot)com>
2010-12-01 14:20:32 from Robert Haas <robertmhaas(at)gmail(dot)com>
2010-12-01 14:24:07 from Andres Freund <andres(at)anarazel(dot)de>
2010-12-01 15:26:24 from "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>
2010-12-05 01:04:43 from Jeff Janes <jeff(dot)janes(at)gmail(dot)com>
2010-12-06 02:18:16 from Robert Haas <robertmhaas(at)gmail(dot)com>
2010-12-06 17:38:42 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2010-12-06 17:49:16 from Josh Berkus <josh(at)agliodbs(dot)com>
2010-12-06 17:55:22 from Robert Haas <robertmhaas(at)gmail(dot)com>
2010-12-05 09:47:37 from Stefan Kaltenbrunner <stefan(at)kaltenbrunner(dot)cc>
2010-12-05 18:59:13 from Josh Berkus <josh(at)agliodbs(dot)com>
2010-12-05 19:45:17 from Rob Wultsch <wultsch(at)gmail(dot)com>
2010-12-05 20:17:25 from Rob Wultsch <wultsch(at)gmail(dot)com>
2010-12-06 01:58:52 from Robert Haas <robertmhaas(at)gmail(dot)com>
2010-12-06 01:59:41 from Robert Haas <robertmhaas(at)gmail(dot)com>
2010-12-06 02:35:25 from Rob Wultsch <wultsch(at)gmail(dot)com>
2010-12-06 02:44:02 from Robert Haas <robertmhaas(at)gmail(dot)com>
2010-12-06 17:57:44 from Josh Berkus <josh(at)agliodbs(dot)com>
2010-12-06 18:05:22 from Robert Haas <robertmhaas(at)gmail(dot)com>
2010-12-06 19:47:00 from Josh Berkus <josh(at)agliodbs(dot)com>
2010-12-07 02:09:56 from Robert Haas <robertmhaas(at)gmail(dot)com>
2010-12-07 02:37:01 from Alvaro Herrera <alvherre(at)commandprompt(dot)com>
2010-12-07 02:48:55 from Josh Berkus <josh(at)agliodbs(dot)com>
2010-12-07 06:41:07 from Craig Ringer <craig(at)postnewspapers(dot)com(dot)au>
2010-12-07 02:55:11 from Robert Haas <robertmhaas(at)gmail(dot)com>
2010-11-30 01:09:39 from Bruce Momjian <bruce(at)momjian(dot)us>
2010-11-28 20:45:18 from Bruce Momjian <bruce(at)momjian(dot)us>
2010-11-24 20:06:47 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2010-11-24 19:32:20 from Andres Freund <andres(at)anarazel(dot)de>
Lists:
pgsql-hackers
On Wednesday 01 December 2010 15:20:32 Robert Haas wrote:
> On Tue, Nov 30, 2010 at 11:32 PM, Jeff Janes <jeff(dot)janes(at)gmail(dot)com> wrote:
> > On 11/28/10, Robert Haas <robertmhaas(at)gmail(dot)com> wrote:
> >> To some degree we're a
> >> victim of our own flexible and extensible architecture here, but I
> >> find it pretty unsatisfying to just say, OK, well, we're slow.
> >
> > What about "well OK, we have PGbouncer"? Are there fixable
> > short-comings that it has which could make the issue less of an issue?
>
> We do have pgbouncer, and pgpool-II, and that's a good thing. But it
> also requires proxying every interaction with the database through an
> intermediate piece of software, which is not free. An in-core
> solution ought to be able to arrange for each new connection to be
> directly attached to an existing backend, using file-descriptor
> passing. Tom has previously complained that this isn't portable, but
> a little research suggests that it is supported on at least Linux, Mac
> OS X, FreeBSD, OpenBSD, Solaris, and Windows, so in practice the
> percentage of our user base who could benefit seems like it would
> likely be very high.
HPUX and AIX allow fd transfer as well. I still don't see what even remotely
relevant platform would be a problem.
Andres
In response to
pgsql-hackers by date
Next :From: Tom LaneDate: 2010-12-01 14:27:21Subject : Re: FK's to refer to rows in inheritance child Previous :From : Robert HaasDate : 2010-12-01 14:20:32Subject : Re: profiling connection overhead
