Re: BUG #14917: process hang on create index

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Boris Sagadin <sagadin(at)gmail(dot)com>
Cc: Michael Paquier <michael(dot)paquier(at)gmail(dot)com>, PostgreSQL mailing lists <pgsql-bugs(at)postgresql(dot)org>
Subject: Re: BUG #14917: process hang on create index
Date: 2017-11-18 15:54:17
Message-ID: 7707.1511020457@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

Boris Sagadin <sagadin(at)gmail(dot)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

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message AP 2017-11-19 22:43:53 Re: 10.1: hash index size exploding on vacuum full analyze
Previous Message Boris Sagadin 2017-11-18 09:13:29 Re: BUG #14917: process hang on create index