Re: BUG #6325: Useless Index updates - Mailing list pgsql-bugs

From Andreas Karlsson
Subject Re: BUG #6325: Useless Index updates
Date
Msg-id 4EDC0D76.4060402@proxel.se
Whole thread Raw
In response to Re: BUG #6325: Useless Index updates  (Craig Ringer <ringerc@ringerc.id.au>)
Responses Re: BUG #6325: Useless Index updates
List pgsql-bugs
On 2011-12-04 15:02, Craig Ringer wrote:
> - The index isn't always updated. Check out HOT (introduced in 8.4, the
> release after your current one) which reduces unnecessary index
> updates in cases where the old and new row can fit on the same
> heap page.

Minor correction: HOT was introduced in 8.3.

http://www.postgresql.org/docs/9.1/static/release-8-3.html

--
Andreas Karlsson

pgsql-bugs by date:

Previous
From: hubert depesz lubaczewski
Date:
Subject: Re: BUG #6325: Useless Index updates
Next
From: Craig Ringer
Date:
Subject: Re: BUG #6325: Useless Index updates