BUG #14917: process hang on create index

From: sagadin(at)gmail(dot)com
To: pgsql-bugs(at)postgresql(dot)org
Cc: sagadin(at)gmail(dot)com
Subject: BUG #14917: process hang on create index
Date: 2017-11-17 11:26:00
Message-ID: 20171117112600.1465.35972@wrigleys.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

The following bug has been logged on the website:

Bug reference: 14917
Logged by: Boris Sagadin
Email address: sagadin(at)gmail(dot)com
PostgreSQL version: 9.5.10
Operating system: Ubuntu 16.04, CentOS 7
Description:

This happens just on one customer table, UTF-8 is used. Can recreate and
provide more details.

CREATE INDEX on this table never ends. Data can be inserted into table.
Table can be dumped and recreated, but creating index always hangs the
process.

perf top -u postgres on CenOS 7.4, on Ubuntu is very similar.

97.24% libc-2.17.so [.] get_next_seq
0.94% libc-2.17.so [.] __strcoll_l
0.50% postgres [.] pg_detoast_datum_packed
0.21% libc-2.17.so [.] __memcpy_ssse3_back

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Ashutosh Bapat 2017-11-17 12:09:32 Re: [BUGS] BUG #14890: Error grouping by same column twice using FDW
Previous Message Wim Bertels 2017-11-17 11:04:22 psql ignores server port setting through alter system when connecting?