YAMAMOTO Takashi <yamt@mwd.biglobe.ne.jp> wrote:
>> Did you notice whether the loop involved multiple tuples within a
>> single page?
>
> if i understand correctly, yes.
>
> the following is a snippet of my debug code (dump targets when
> triggerCheckTargetForConflictsIn loops >1000 times) and its
> output.the same locktag_field3 value means the same page, right?
Right.
> the table seems mostly hot-updated, if it matters.
> idx_scan | 53681
> idx_tup_fetch | 52253
> n_tup_ins | 569
> n_tup_upd | 12054
> n_tup_del | 476
> n_tup_hot_upd | 12041
> n_live_tup | 93
> n_dead_tup | 559
That probably matters a lot.
> analyze_count | 4922528128875102208
> autoanalyze_count | 7598807461784802080
>
> (values in the last two columns seems bogus.
> i don't know if it's related or not.)
That seems unlikely to be related to this problem. It sure does
look odd, though. Maybe post that in a separate thread?
Thanks for all the additional info. I'll keep digging.
-Kevin