On Wed, Jul 13, 2011 at 11:10 AM, lars <lhofhansl@xxxxxxxxx> wrote: ... > => update test set created_by = '000000000000001' where tenant = > '000000000000001'; > UPDATE 3712 ... > > There seems to be definitely something funky going on. Since created_by is > indexed it shouldn't do any HOT logic. Once the update has been run once, further executions are degenerate (they replace the updated indexed column with the same value it already holds). The HOT code detects this and uses a HOT update in this case despite the apparent update of an indexed column. Cheers, Jeff -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
