Re: BUG #6325: Useless Index updates

From: Andreas Karlsson <andreas(at)proxel(dot)se>
To: Craig Ringer <ringerc(at)ringerc(dot)id(dot)au>
Cc: dmigowski(at)ikoffice(dot)de, pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #6325: Useless Index updates
Date: 2011-12-05 00:16:54
Message-ID: 4EDC0D76.4060402@proxel.se
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs pgsql-general

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

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Craig Ringer 2011-12-05 00:25:31 Re: BUG #6325: Useless Index updates
Previous Message hubert depesz lubaczewski 2011-12-04 20:07:21 Re: BUG #6325: Useless Index updates

Browse pgsql-general by date

  From Date Subject
Next Message Craig Ringer 2011-12-05 00:25:31 Re: BUG #6325: Useless Index updates
Previous Message Tom Lane 2011-12-04 21:23:52 Re: Shared memory usage in PostgreSQL 9.1