Re: Too slow "Analyze" for the table with data in Thai language - Mailing list pgsql-bugs

From Tom Lane
Subject Re: Too slow "Analyze" for the table with data in Thai language
Date
Msg-id 31992.1467732789@sss.pgh.pa.us
Whole thread Raw
In response to Too slow "Analyze" for the table with data in Thai language  ("Timur Luchkin" <timur.luchkin@gmail.com>)
Responses Re: Too slow "Analyze" for the table with data in Thai language
List pgsql-bugs
"Timur Luchkin" <timur.luchkin@gmail.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

pgsql-bugs by date:

Previous
From: "Timur Luchkin"
Date:
Subject: Too slow "Analyze" for the table with data in Thai language
Next
From: andrew@tao11.riddles.org.uk
Date:
Subject: BUG #14228: replication slot catalog_xmin not cleared on slot reuse