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