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 -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs
