Postgres Pro
Downloads
Home   >   mailing lists

Re: Hot Standby btree delete records and vacuum_defer_cleanup_age - Mailing list pgsql-hackers

From Simon Riggs
Subject Re: Hot Standby btree delete records and vacuum_defer_cleanup_age
Date
Msg-id 1291881346.2872.1988.camel@ebony
Whole thread Raw
In response to Re: Hot Standby btree delete records and vacuum_defer_cleanup_age  (Heikki Linnakangas <heikki.linnakangas@enterprisedb.com>)
Responses Re: Hot Standby btree delete records and vacuum_defer_cleanup_age  (Fujii Masao <masao.fujii@gmail.com>)
List pgsql-hackers
Tree view 
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.

-- Simon Riggs           http://www.2ndQuadrant.com/books/PostgreSQL Development, 24x7 Support, Training and Services

pgsql-hackers by date:

Previous
From: Simon Riggs
Date:
Subject: Re: Hot Standby btree delete records and vacuum_defer_cleanup_age
Next
From: Simon Riggs
Date:
Subject: Re: On-the-fly index tuple deletion vs. hot_standby