Re: postgresql infinite loop

郭 勇 <guoyongxhzhf@icloud.com> writes:
> I have a postgresql infinite problem. 
> when inserting data, a postgresql process involve to infinite loop and cpu usage is 100%. perf top show that
LWacquirelockis most costful.
 
> Callstack is below. 

Given that stack trace, I'd have to guess that this is caused by a
circular chain of right-links in a btree index.  How it got that
way is hard to say, but reindexing the index ought to fix it.

If you can show a recipe for producing an index that's broken
this way from a standing start, we'd be very interested.
        regards, tom lane