From:
Fujii Masao <masao(dot)fujii(at)gmail(dot)com>
To:
Heikki Linnakangas <heikki(dot)linnakangas(at)enterprisedb(dot)com>
Cc:
Simon Riggs <simon(at)2ndquadrant(dot)com>, pgsql-hackers(at)postgresql(dot)org
Subject:
Re: Re: [COMMITTERS] pgsql: Write a WAL record whenever we perform an operation without
Date:
2010-02-01 10:36:59
Message-ID:
3f0b79eb1002010236g68009c3dmdaf8c985bcbbbc56@mail.gmail.com (view raw or flat )
Thread:
2010-01-20 19:43:40 from heikki(at)postgresql(dot)org (Heikki Linnakangas)
2010-01-21 03:40:05 from Robert Haas <robertmhaas(at)gmail(dot)com>
2010-01-21 03:56:20 from Takahiro Itagaki <itagaki(dot)takahiro(at)oss(dot)ntt(dot)co(dot)jp>
2010-02-01 08:40:57 from Simon Riggs <simon(at)2ndQuadrant(dot)com>
2010-02-01 09:33:44 from Heikki Linnakangas <heikki(dot)linnakangas(at)enterprisedb(dot)com>
2010-02-01 09:53:36 from Simon Riggs <simon(at)2ndQuadrant(dot)com>
2010-02-01 10:11:56 from Heikki Linnakangas <heikki(dot)linnakangas(at)enterprisedb(dot)com>
2010-02-01 10:14:56 from Simon Riggs <simon(at)2ndQuadrant(dot)com>
2010-02-01 10:30:43 from Heikki Linnakangas <heikki(dot)linnakangas(at)enterprisedb(dot)com>
2010-02-01 10:38:44 from Fujii Masao <masao(dot)fujii(at)gmail(dot)com>
2010-02-01 10:40:51 from Heikki Linnakangas <heikki(dot)linnakangas(at)enterprisedb(dot)com>
2010-02-02 04:40:14 from Fujii Masao <masao(dot)fujii(at)gmail(dot)com>
2010-02-03 10:03:00 from Heikki Linnakangas <heikki(dot)linnakangas(at)enterprisedb(dot)com>
2010-02-03 10:19:19 from Tatsuo Ishii <ishii(at)postgresql(dot)org>
2010-02-03 10:50:06 from Heikki Linnakangas <heikki(dot)linnakangas(at)enterprisedb(dot)com>
2010-02-01 10:46:06 from Simon Riggs <simon(at)2ndQuadrant(dot)com>
2010-02-01 09:58:00 from Fujii Masao <masao(dot)fujii(at)gmail(dot)com>
2010-02-01 10:15:21 from Fujii Masao <masao(dot)fujii(at)gmail(dot)com>
2010-02-01 10:27:15 from Heikki Linnakangas <heikki(dot)linnakangas(at)enterprisedb(dot)com>
2010-02-01 10:36:59 from Fujii Masao <masao(dot)fujii(at)gmail(dot)com>
2010-02-01 16:13:50 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Lists:
pgsql-committers pgsql-hackers
On Mon, Feb 1, 2010 at 7:27 PM, Heikki Linnakangas
<heikki(dot)linnakangas(at)enterprisedb(dot)com> wrote:
> Fujii Masao wrote:
>> The cause of the problem seems to be the new heap created by
>> rebuild_relation() and copy_heap_data(), i.e., new VACUUM FULL.
>> Since it's not a temporary heap, its rd_istemp is off. OTOH
>> it needs to be synced after physical copy from old heap.
>
> Why does it need to be synced?
>
> ISTM the bug is that rd_istemp is off at that point.
Umm... ISTM that new heap needs to be synced before calling
swap_relation_files(), but, in the now, I'm not sure whether
it's really required or not. Sorry.
Regards,
--
Fujii Masao
NIPPON TELEGRAPH AND TELEPHONE CORPORATION
NTT Open Source Software Center
In response to
Responses
pgsql-hackers by date
Next :From: Fujii MasaoDate: 2010-02-01 10:38:44Subject : Re: Re: [COMMITTERS] pgsql: Write a WAL record whenever we perform an operation withoutPrevious :From : Rafael MartinezDate : 2010-02-01 10:33:56Subject : PITR - Bug or feature?
pgsql-committers by date
Next :From: Fujii MasaoDate: 2010-02-01 10:38:44Subject : Re: Re: [COMMITTERS] pgsql: Write a WAL record whenever we perform an operation withoutPrevious :From : Heikki LinnakangasDate : 2010-02-01 10:30:43Subject : Re: [COMMITTERS] pgsql: Write a WAL record whenever we perform an
operation without
