Re: select distinct on varchar - wild performance differences!

From: Elliott Bennett <pgmail(at)dhtns(dot)com>
To: pgsql-performance(at)postgresql(dot)org
Subject: Re: select distinct on varchar - wild performance differences!
Date: 2005-06-23 17:09:07
Message-ID: 20050623170907.GA32134@turing.dhtns.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

hah! That did it. Setting to 'C' makes it just as fast as the other
machines. I think it defaulted to en_US...

Thanks!

-Elliott

On Thu, Jun 23, 2005 at 11:34:55AM -0400, Tom Lane wrote:
> Elliott Bennett <pgmail(at)dhtns(dot)com> writes:
> > Anyone have any ideas as to what may be up with machine B?
>
> Different locale setting? strcoll() can be horribly slow in some
> locales ...
>
> regards, tom lane
>
> ---------------------------(end of broadcast)---------------------------
> TIP 8: explain analyze is your friend
>

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Tom Lane 2005-06-23 17:15:24 Re: Performance Tuning Article
Previous Message Dave Cramer 2005-06-23 16:16:57 Re: Performance Tuning Article