On 12/05/2011 08:16 AM, Andreas Karlsson wrote:
> 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
Whoops, thanks. In that case the OP is already getting the benefit of
reduced index updates as much as is possible with PostgreSQL's MVCC design.
--
Craig Ringer