Re: Too slow "Analyze" for the table with data in Thai language

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Timur Luchkin" <timur(dot)luchkin(at)gmail(dot)com>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: Too slow "Analyze" for the table with data in Thai language
Date: 2016-07-05 15:33:09
Message-ID: 31992.1467732789@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

"Timur Luchkin" <timur(dot)luchkin(at)gmail(dot)com> writes:
> I have a table (dictionary) with international data in many languages.
> After the migration to the new hardware the 'analyze' operation instead
> of 5 seconds takes 3-5 minutes now (with 100% cpu core usage).
> Investigation showed that slow performance introduced by new glibc.
> Previous versions of glibc (2.15 - 2.16) works fine, new versions (2.22
> and 2.23) have this problem (versions between 2.17 and 2.21 were not
> tested).

So ... why do you think this is a Postgres bug and not a glibc bug?
We have no control over what happens inside strcoll().

regards, tom lane

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message andrew 2016-07-05 17:35:02 BUG #14228: replication slot catalog_xmin not cleared on slot reuse
Previous Message Timur Luchkin 2016-07-05 11:47:41 Too slow "Analyze" for the table with data in Thai language