From:
Jeff Janes <jeff(dot)janes(at)gmail(dot)com>
To:
Robert Haas <robertmhaas(at)gmail(dot)com>
Cc:
Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Bruce Momjian <bruce(at)momjian(dot)us>, Andres Freund <andres(at)anarazel(dot)de>, pgsql-hackers(at)postgresql(dot)org, Heikki Linnakangas <heikki(dot)linnakangas(at)enterprisedb(dot)com>
Subject:
Re: profiling connection overhead
Date:
2010-12-01 04:32:23
Message-ID:
AANLkTik2Y-03aZ-wxNJ3k=dVirCPvcce9-7DFFrFSPXw@mail.gmail.com (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 11/28/10, Robert Haas <robertmhaas(at)gmail(dot)com> wrote:
>
> In a close race, I don't think we should get bogged down in
> micro-optimization here, both because micro-optimizations may not gain
> much and because what works well on one platform may not do much at
> all on another. The more general issue here is what to do about our
> high backend startup costs. Beyond trying to recycle backends for new
> connections, as I've previous proposed and with all the problems it
> entails,
Is there a particular discussion of that matter you could point me to?
> the only thing that looks promising here is to try to somehow
> cut down on the cost of populating the catcache and relcache, not that
> I have a very clear idea how to do that. This has to be a soluble
> problem because other people have solved it.
Oracle's backend start up time seems to be way higher than PG's.
Their main solution is something that is fundamentally a built in
connection pooler with some bells and whistles built in. I'm not
sure "other people" you had in mind--Oracle is generally the one that
pops to my mind.
> 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?
Cheers,
Jeff
In response to
Responses
pgsql-hackers by date
Next :From: Itagaki TakahiroDate: 2010-12-01 04:53:47Subject : Re: SQL/MED - core functionalityPrevious :From : Robert HaasDate : 2010-12-01 04:27:35Subject : Re: unlogged tables
