Re: Scaling XLog insertion (was Re: Moving more work outside
WALInsertLock)
From:
Heikki Linnakangas <heikki(dot)linnakangas(at)enterprisedb(dot)com>
To:
Robert Haas <robertmhaas(at)gmail(dot)com>
Cc:
PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject:
Re: Scaling XLog insertion (was Re: Moving more work outside
WALInsertLock)
Date:
2012-01-20 14:11:48
Message-ID:
4F197624.60907@enterprisedb.com (view raw or flat )
Thread:
2011-12-15 13:51:33 from Heikki Linnakangas <heikki(dot)linnakangas(at)enterprisedb(dot)com>
2011-12-15 14:32:02 from Andres Freund <andres(at)anarazel(dot)de>
2011-12-15 15:34:55 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2011-12-15 16:32:47 from Jeff Janes <jeff(dot)janes(at)gmail(dot)com>
2011-12-15 16:48:47 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2011-12-15 18:50:52 from Heikki Linnakangas <heikki(dot)linnakangas(at)enterprisedb(dot)com>
2011-12-15 23:42:07 from Simon Riggs <simon(at)2ndQuadrant(dot)com>
2011-12-16 03:27:37 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2011-12-16 12:07:19 from Heikki Linnakangas <heikki(dot)linnakangas(at)enterprisedb(dot)com>
2011-12-16 12:37:33 from Simon Riggs <simon(at)2ndQuadrant(dot)com>
2011-12-16 12:50:24 from Heikki Linnakangas <heikki(dot)linnakangas(at)enterprisedb(dot)com>
2011-12-16 13:03:13 from Simon Riggs <simon(at)2ndQuadrant(dot)com>
2011-12-16 13:42:40 from Heikki Linnakangas <heikki(dot)linnakangas(at)enterprisedb(dot)com>
2011-12-23 08:13:43 from Heikki Linnakangas <heikki(dot)linnakangas(at)enterprisedb(dot)com>
2011-12-23 08:15:01 from Heikki Linnakangas <heikki(dot)linnakangas(at)enterprisedb(dot)com>
2011-12-23 13:23:09 from Robert Haas <robertmhaas(at)gmail(dot)com>
2011-12-23 19:54:23 from Heikki Linnakangas <heikki(dot)linnakangas(at)enterprisedb(dot)com>
2011-12-24 09:48:40 from Fujii Masao <masao(dot)fujii(at)gmail(dot)com>
2011-12-25 19:48:24 from Robert Haas <robertmhaas(at)gmail(dot)com>
2012-01-07 09:31:04 from Heikki Linnakangas <heikki(dot)linnakangas(at)enterprisedb(dot)com>
2012-01-09 13:44:52 from Simon Riggs <simon(at)2ndQuadrant(dot)com>
2012-01-09 14:29:27 from Heikki Linnakangas <heikki(dot)linnakangas(at)enterprisedb(dot)com>
2012-01-09 19:59:08 from Simon Riggs <simon(at)2ndQuadrant(dot)com>
2012-01-14 14:32:59 from Heikki Linnakangas <heikki(dot)linnakangas(at)enterprisedb(dot)com>
2012-01-20 13:32:46 from Robert Haas <robertmhaas(at)gmail(dot)com>
2012-01-20 14:11:48 from Heikki Linnakangas <heikki(dot)linnakangas(at)enterprisedb(dot)com>
2012-01-20 14:37:38 from Simon Riggs <simon(at)2ndQuadrant(dot)com>
2012-01-31 15:35:35 from Fujii Masao <masao(dot)fujii(at)gmail(dot)com>
2012-02-02 07:46:50 from Heikki Linnakangas <heikki(dot)linnakangas(at)enterprisedb(dot)com>
2012-02-08 18:32:52 from Jeff Janes <jeff(dot)janes(at)gmail(dot)com>
2012-02-09 10:25:29 from Fujii Masao <masao(dot)fujii(at)gmail(dot)com>
2012-02-09 11:02:04 from Fujii Masao <masao(dot)fujii(at)gmail(dot)com>
2012-02-12 23:04:59 from Jeff Janes <jeff(dot)janes(at)gmail(dot)com>
2012-02-13 11:37:09 from Heikki Linnakangas <heikki(dot)linnakangas(at)enterprisedb(dot)com>
2012-02-13 17:13:32 from Fujii Masao <masao(dot)fujii(at)gmail(dot)com>
2012-02-15 16:01:37 from Heikki Linnakangas <heikki(dot)linnakangas(at)enterprisedb(dot)com>
2012-02-15 16:52:15 from Fujii Masao <masao(dot)fujii(at)gmail(dot)com>
2012-02-15 20:02:07 from Heikki Linnakangas <heikki(dot)linnakangas(at)enterprisedb(dot)com>
2012-02-16 09:15:42 from Fujii Masao <masao(dot)fujii(at)gmail(dot)com>
2012-02-16 11:31:04 from Fujii Masao <masao(dot)fujii(at)gmail(dot)com>
2012-02-17 08:59:19 from Heikki Linnakangas <heikki(dot)linnakangas(at)enterprisedb(dot)com>
2012-02-17 05:27:18 from Fujii Masao <masao(dot)fujii(at)gmail(dot)com>
2012-02-17 15:36:58 from Heikki Linnakangas <heikki(dot)linnakangas(at)enterprisedb(dot)com>
2012-02-18 18:01:04 from Jeff Janes <jeff(dot)janes(at)gmail(dot)com>
2012-02-20 09:09:14 from Fujii Masao <masao(dot)fujii(at)gmail(dot)com>
2012-02-20 06:00:06 from Amit Kapila <amit(dot)kapila(at)huawei(dot)com>
2012-03-05 08:31:56 from Heikki Linnakangas <heikki(dot)linnakangas(at)enterprisedb(dot)com>
2012-02-21 11:19:41 from Fujii Masao <masao(dot)fujii(at)gmail(dot)com>
2012-02-22 01:34:01 from Fujii Masao <masao(dot)fujii(at)gmail(dot)com>
2012-02-25 20:46:54 from Jeff Janes <jeff(dot)janes(at)gmail(dot)com>
2012-03-05 16:34:57 from Heikki Linnakangas <heikki(dot)linnakangas(at)enterprisedb(dot)com>
2012-03-05 16:50:02 from Heikki Linnakangas <heikki(dot)linnakangas(at)enterprisedb(dot)com>
2012-03-05 17:17:26 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2012-03-06 12:52:09 from Fujii Masao <masao(dot)fujii(at)gmail(dot)com>
2012-03-06 15:07:00 from Heikki Linnakangas <heikki(dot)linnakangas(at)enterprisedb(dot)com>
2012-03-06 15:11:09 from Robert Haas <robertmhaas(at)gmail(dot)com>
2012-03-06 15:12:35 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2012-03-06 19:34:24 from Heikki Linnakangas <heikki(dot)linnakangas(at)enterprisedb(dot)com>
2012-03-06 20:32:59 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2012-03-07 07:07:37 from Fujii Masao <masao(dot)fujii(at)gmail(dot)com>
2012-03-07 08:35:44 from Simon Riggs <simon(at)2ndQuadrant(dot)com>
2012-03-07 14:24:37 from Alvaro Herrera <alvherre(at)commandprompt(dot)com>
2012-03-07 15:04:19 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2012-03-07 15:17:10 from Simon Riggs <simon(at)2ndQuadrant(dot)com>
2012-03-07 15:28:38 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2012-03-09 10:04:03 from Heikki Linnakangas <heikki(dot)linnakangas(at)enterprisedb(dot)com>
2012-03-09 10:34:53 from Fujii Masao <masao(dot)fujii(at)gmail(dot)com>
2012-03-09 10:45:05 from Heikki Linnakangas <heikki(dot)linnakangas(at)enterprisedb(dot)com>
2012-03-12 16:59:36 from Jeff Janes <jeff(dot)janes(at)gmail(dot)com>
2012-03-13 04:55:32 from Fujii Masao <masao(dot)fujii(at)gmail(dot)com>
2012-03-12 19:33:30 from Heikki Linnakangas <heikki(dot)linnakangas(at)enterprisedb(dot)com>
2012-03-14 20:52:38 from Heikki Linnakangas <heikki(dot)linnakangas(at)enterprisedb(dot)com>
2012-03-21 11:14:28 from Fujii Masao <masao(dot)fujii(at)gmail(dot)com>
2012-03-21 11:52:57 from Heikki Linnakangas <heikki(dot)linnakangas(at)enterprisedb(dot)com>
2012-03-21 12:27:45 from Robert Haas <robertmhaas(at)gmail(dot)com>
2012-03-21 13:59:49 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2012-03-22 01:32:35 from Fujii Masao <masao(dot)fujii(at)gmail(dot)com>
2012-03-06 14:20:11 from Fujii Masao <masao(dot)fujii(at)gmail(dot)com>
2012-03-07 15:44:19 from Jeff Janes <jeff(dot)janes(at)gmail(dot)com>
2012-01-08 20:22:57 from Simon Riggs <simon(at)2ndQuadrant(dot)com>
2011-12-24 19:41:04 from Greg Stark <stark(at)mit(dot)edu>
2011-12-15 19:06:08 from Heikki Linnakangas <heikki(dot)linnakangas(at)enterprisedb(dot)com>
2011-12-15 23:37:18 from Simon Riggs <simon(at)2ndQuadrant(dot)com>
Lists:
pgsql-hackers
On 20.01.2012 15:32, Robert Haas wrote:
> On Sat, Jan 14, 2012 at 9:32 AM, Heikki Linnakangas
> <heikki(dot)linnakangas(at)enterprisedb(dot)com> wrote:
>> Here's another version of the patch to make XLogInsert less of a bottleneck
>> on multi-CPU systems. The basic idea is the same as before, but several bugs
>> have been fixed, and lots of misc. clean up has been done.
>
> This seems to need a rebase.
Here you go.
--
Heikki Linnakangas
EnterpriseDB http://www.enterprisedb.com
In response to
Responses
pgsql-hackers by date
Next :From: Robert HaasDate: 2012-01-20 14:19:51Subject : Re: JSON for PG 9.2Previous :From : Dimitri FontaineDate : 2012-01-20 13:52:25Subject : Re: Inline Extension
