Re: BUG #14917: process hang on create index - Mailing list pgsql-bugs

From Tom Lane
Subject Re: BUG #14917: process hang on create index
Date
Msg-id 7707.1511020457@sss.pgh.pa.us
Whole thread Raw
In response to Re: BUG #14917: process hang on create index  (Boris Sagadin <sagadin@gmail.com>)
Responses Re: BUG #14917: process hang on create index  (Boris Sagadin <sagadin@gmail.com>)
List pgsql-bugs
Boris Sagadin <sagadin@gmail.com> writes:
>  I don't know how to create a small, reproducible example, customer
> personal data is contained.

Well, then you're going to have to do your own debugging, because the
information you've provided so far is just about useless for identifying
the problem.

One place to start is by collecting a few stack traces while it seems to
be looping:

https://wiki.postgresql.org/wiki/Generating_a_stack_trace_of_a_PostgreSQL_backend
        regards, tom lane


pgsql-bugs by date:

Previous
From: Boris Sagadin
Date:
Subject: Re: BUG #14917: process hang on create index
Next
From: AP
Date:
Subject: Re: 10.1: hash index size exploding on vacuum full analyze