Re: Serious Performance Loss in 7.0.2??

From: Tatsuo Ishii <t-ishii(at)sra(dot)co(dot)jp>
To: tgl(at)sss(dot)pgh(dot)pa(dot)us
Cc: tperdue(at)valinux(dot)com, pgsql-hackers(at)hub(dot)org
Subject: Re: Serious Performance Loss in 7.0.2??
Date: 2000-07-13 04:31:12
Message-ID: 20000713133112W.t-ishii@sra.co.jp
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

> All else being equal that is. Since this is a sort on a char() field,
> perhaps all else is not equal. In particular I'm suddenly wondering
> if your 7.0 installation was compiled with LOCALE or MULTIBYTE support
> and your 6.5 not. A few tens of thousands of strcoll() calls to do the
> sort comparisons might account for the slowdown...

Just to clarify, MULTIBYTE never calls strcoll() as far as I know.
--
Tatsuo Ishii

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2000-07-13 05:02:09 Re: Some Improvement
Previous Message Tom Lane 2000-07-13 04:20:10 Re: Some Improvement