From:
Peter Eisentraut <peter_e(at)gmx(dot)net>
To:
Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc:
Jeff Janes <jeff(dot)janes(at)gmail(dot)com>, Andres Freund <andres(at)anarazel(dot)de>,
Robert Haas <robertmhaas(at)gmail(dot)com>, 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 05:14:56
Message-ID:
1291180496.601.1.camel@vanquo.pezone.net (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 tis, 2010-11-30 at 15:49 -0500, Tom Lane wrote:
> Peter Eisentraut <peter_e(at)gmx(dot)net> writes:
> > On mån, 2010-11-29 at 13:10 -0500, Tom Lane wrote:
> >> Rolling in calloc in place of
> >> malloc/memset made no particular difference either, which says that
> >> Fedora 13's glibc does not have any optimization for that case as I'd
> >> hoped.
>
> > glibc's calloc is either mmap of /dev/zero or malloc followed by memset.
>
> Hmm. I would have expected to see a difference then. Do you know what
> conditions are needed to cause the mmap to be used?
Check out the mallopt(3) man page. It contains a few tunable malloc
options that may be useful for your investigation.
In response to
pgsql-hackers by date
Next :From: Hitoshi HaradaDate: 2010-12-01 05:22:12Subject : Re: SQL/MED - core functionalityPrevious :From : Itagaki TakahiroDate : 2010-12-01 04:53:47Subject : Re: SQL/MED - core functionality
