Postgres Pro
Downloads
Home   >   mailing lists

Re: BUG #14917: process hang on create index - Mailing list pgsql-bugs

From Boris Sagadin
Subject Re: BUG #14917: process hang on create index
Date
Msg-id CAF8kEZuD_buuCbP70zhzDHKqK0LJ-Vde9H3gYQFEF==F-j_J2A@mail.gmail.com
Whole thread Raw
In response to Re: BUG #14917: process hang on create index  (Peter Geoghegan <pg@bowt.ie>)
Responses Re: BUG #14917: process hang on create index  (Peter Geoghegan <pg@bowt.ie>)
List pgsql-bugs
Tree view
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 by date:

Previous
From: Ashutosh Bapat
Date:
Subject: Re: [BUGS] BUG #14890: Error grouping by same column twice using FDW
Next
From: Amit Kapila
Date:
Subject: Re: 10.1: hash index size exploding on vacuum full analyze