From:
"Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>
To:
"Jeff Janes" <jeff(dot)janes(at)gmail(dot)com>, "Robert Haas" <robertmhaas(at)gmail(dot)com>
Cc:
"Andres Freund" <andres(at)anarazel(dot)de>, "Heikki Linnakangas" <heikki(dot)linnakangas(at)enterprisedb(dot)com>, "Bruce Momjian" <bruce(at)momjian(dot)us>, <pgsql-hackers(at)postgresql(dot)org>,"Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Subject:
Re: profiling connection overhead
Date:
2010-12-01 15:26:24
Message-ID:
4CF614C00200002500038000@gw.wicourts.gov (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
Robert Haas <robertmhaas(at)gmail(dot)com> wrote:
> Jeff Janes <jeff(dot)janes(at)gmail(dot)com> wrote:
>> Oracle's backend start up time seems to be way higher than PG's.
> Interesting. How about MySQL and SQL Server?
My recollection of Sybase ASE is that establishing a connection
doesn't start a backend or even a thread. It establishes a network
connection and associates network queues and a connection context
structure with it. "Engine" threads with CPU affinity (and a few
miscellaneous "worker" threads, too, if I remember right) do all the
work in a queue-based fashion.
Last I worked with MS SQL Server it was based on the Sybase code and
therefore worked the same way. I know they've made a lot of changes
in the last five years (including switching to MVCC and adding
snapshot isolation in addition to the already-existing serializable
isolation), so I don't know whether connection startup cost has
changed along the way.
-Kevin
In response to
pgsql-hackers by date
Next :From: Tom LaneDate: 2010-12-01 15:36:50Subject : Re: KNNGIST next step: adjusting indexAM API Previous :From : Dimitri FontaineDate : 2010-12-01 15:24:17Subject : Re: KNNGIST next step: adjusting indexAM API
