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  (Peter Geoghegan <pg@bowt.ie>)
Список 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 по дате отправления:

Предыдущее
От: Ashutosh Bapat
Дата:
Сообщение: Re: [BUGS] BUG #14890: Error grouping by same column twice using FDW
Следующее
От: Amit Kapila
Дата:
Сообщение: Re: 10.1: hash index size exploding on vacuum full analyze