Re: select distinct on varchar - wild performance differences!

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Elliott Bennett <pgmail(at)dhtns(dot)com>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: select distinct on varchar - wild performance differences!
Date: 2005-06-23 15:34:55
Message-ID: 5595.1119540895@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

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

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Dave Cramer 2005-06-23 16:16:57 Re: Performance Tuning Article
Previous Message Tobias Brox 2005-06-23 15:31:12 Re: Querying 19million records very slowly