Re: BUG #14917: process hang on create index
| От | Boris Sagadin |
|---|---|
| Тема | Re: BUG #14917: process hang on create index |
| Дата | |
| Msg-id | CAF8kEZuD_buuCbP70zhzDHKqK0LJ-Vde9H3gYQFEF==F-j_J2A@mail.gmail.com обсуждение исходный текст |
| Ответ на | Re: BUG #14917: process hang on create index (Peter Geoghegan <pg@bowt.ie>) |
| Ответы |
Re: BUG #14917: process hang on create index
|
| Список | pgsql-bugs |
No string is over 200 chars. By function name I assumed the get_next_seq is pgsql related, but now I've learned it's glibc. Sorting in shell with same locale is indeed very slow, I used just 1% of data in that column and it finishes sorting in a few minutes. Thanks, I'll check with glibc.
Regards,
Boris
On Mon, Nov 20, 2017 at 7:17 PM, Peter Geoghegan <pg@bowt.ie> wrote:
Boris Sagadin <sagadin@gmail.com> wrote:After a fresh DB start and CREATE INDEX idx_table123_fast ON table123 USING
btree (k, n), strace looks normal to a point:brk(0x7f13d970a000) = 0x7f13d970a000
mmap(NULL, 12587008, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1,
Are these text strings individually very large?
--
Peter Geoghegan
В списке pgsql-bugs по дате отправления: