Re: How can sort performance be so different

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Subject: Re: How can sort performance be so different
From: Peter Geoghegan <pg@xxxxxxx>
Date: Wed, 20 Feb 2019 16:54:52 -0800
Cc: Merlin Moncure <mmoncure@xxxxxxxxx>, pgsql-performance@xxxxxxxxxxxxxxxxxxxx
In-reply-to: <CAH2-Wz=t-Seb=vPx4yTTe0mNsF4xknxeu63s5s-He71pKiNAxA@mail.gmail.com>
References: <CACd=f9feuR3BkZ65Noce_rc2b5R5GYin_9Gd9UaC_rhOBoch5g@mail.gmail.com> <14004.1548787651@sss.pgh.pa.us> <CACd=f9eV=DjLzoa6CXnHpsp5J+gDEQSJ2uH=_u4W=OZuQZ6LBA@mail.gmail.com> <CAH2-WznhLA6TbVQ4Mc5aNUp7hBxbAn6__Mtf7oPeTn7FeOSfmw@mail.gmail.com> <CACd=f9cO5OcmAeBK1M5a3+t8BO7E91Ki0WaLAxFm=FBbon_HDw@mail.gmail.com> <CAHyXU0ydRkdS45XTtEgwk+AYORikQt8VePM0m2b2KkXdNfjYtw@mail.gmail.com> <CACd=f9e3+WRkCLALUyDQXCTgm6vu2-O_N+o+t1oaJAsSVi2aeQ@mail.gmail.com> <CAHyXU0wAGdhSjR8v+4=gX0bJpuXUYRpLExY2Xe-bHiTrDFEvtA@mail.gmail.com> <CACd=f9e3T7+CoUcO0xF+QMbt46s8SaDy9s52M-EcRskX4tr8SA@mail.gmail.com> <CAH2-Wz=t-Seb=vPx4yTTe0mNsF4xknxeu63s5s-He71pKiNAxA@mail.gmail.com>

On Wed, Feb 20, 2019 at 2:25 PM Peter Geoghegan <pg@xxxxxxx> wrote:
> I suspect that the reasons why the Lao locale sorts so much slower may
> also have something to do with the intrinsic cost of supporting more
> complicated rules.

I strongly suspect that it has something to do with the issue
described here specifically:

http://userguide.icu-project.org/collation/concepts#TOC-Thai-Lao-reordering
-- 
Peter Geoghegan

References:
- How can sort performance be so different
  - From: Bob Jolliffe
- Re: How can sort performance be so different
  - From: Tom Lane
- Re: How can sort performance be so different
  - From: Bob Jolliffe
- Re: How can sort performance be so different
  - From: Peter Geoghegan
- Re: How can sort performance be so different
  - From: Bob Jolliffe
- Re: How can sort performance be so different
  - From: Merlin Moncure
- Re: How can sort performance be so different
  - From: Bob Jolliffe
- Re: How can sort performance be so different
  - From: Merlin Moncure
- Re: How can sort performance be so different
  - From: Bob Jolliffe
- Re: How can sort performance be so different
  - From: Peter Geoghegan

Prev by Date: neither CPU nor IO bound, but throttled performance
Next by Date: Re: neither CPU nor IO bound, but throttled performance
Previous by thread: Re: How can sort performance be so different
Next by thread: pgstattupple vs pg_total_relation_size
Index(es):
- Date
- Thread

[Postgresql General] [Postgresql PHP] [PHP Users] [PHP Home] [PHP on Windows] [Kernel Newbies] [PHP Classes] [PHP Books] [PHP Databases] [Yosemite]