Re: Hot Standby btree delete records and vacuum_defer_cleanup_age

From: Fujii Masao <masao(dot)fujii(at)gmail(dot)com>
To: Simon Riggs <simon(at)2ndquadrant(dot)com>
Cc: Heikki Linnakangas <heikki(dot)linnakangas(at)enterprisedb(dot)com>, pgsql-hackers(at)postgresql(dot)org, Noah Misch <noah(at)leadboat(dot)com>
Subject: Re: Hot Standby btree delete records and vacuum_defer_cleanup_age
Date: 2011-03-11 04:21:51
Message-ID: AANLkTikZSj=ZCm79MxwnzRoKO5_Rh8Wm84EHM8KyQzzo@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Thu, Dec 9, 2010 at 4:55 PM, Simon Riggs <simon(at)2ndquadrant(dot)com> wrote:
> On Thu, 2010-12-09 at 00:16 +0100, Heikki Linnakangas wrote:
>> On 09.12.2010 00:10, Heikki Linnakangas wrote:
>> > On 08.12.2010 16:00, Simon Riggs wrote:
>> >> Heikki pointed out to me that the btree delete record processing does
>> >> not respect vacuum_defer_cleanup_age. It should.
>> >>
>> >> Attached patch to implement that.
>> >>
>> >> Looking to commit in next few hours barring objections/suggestions, to
>> >> both HEAD and 9_0_STABLE, in time for next minor release.
>> >
>> > Please note that it was Noah Misch that raised this a while ago:
>> >
>> > http://archives.postgresql.org/pgsql-hackers/2010-11/msg01919.php
>>
>> On closer look, that's not actually the same issue, sorry for the noise..
>
> Heikki, this one *is* important. Will fix. Thanks for the analysis Noah.

Is this an open item for 9.1?

Regards,

--
Fujii Masao
NIPPON TELEGRAPH AND TELEPHONE CORPORATION
NTT Open Source Software Center

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Pavel Stehule 2011-03-11 06:09:37 Re: patch: fix performance problems with repated decomprimation of varlena values in plpgsql
Previous Message Bruce Momjian 2011-03-11 03:59:03 Re: pg_dump -X