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