Re: BUG #14917: process hang on create index

Boris Sagadin <sagadin(at)gmail(dot)com> writes:
> Thanks Tom, I made a few traces on the process, one at the beginning and a
> few later when it seems stuck, below is the output.

Well, it looks to me like it's not hung, it's just busy sorting.
It is making progress, since the successive traces show different
values being compared.

97% of the runtime in strcoll() is a bit weird. strcoll() is known
to be unpleasantly slow in some locales, but that seems excessive.
Perhaps you've discovered a performance bug in strcoll() for certain
input data. That wouldn't be our problem though --- you'd need to
complain to the glibc maintainers.

It'd be interesting to dump out the data in that column into a text file
and see if sorting that with sort(1) (in the same locale!) is equally
slow. If it is, that would confirm the assignment of blame to strcoll().

But the glibc folk would want to see sample data too, so one way or
another you're going to need to sanitize that data enough to show
it to somebody else.

regards, tom lane