Re: select distinct on varchar - wild performance differences!

Поиск
Список
Период
Сортировка
От Elliott Bennett
Тема Re: select distinct on varchar - wild performance differences!
Дата
Msg-id 20050623170907.GA32134@turing.dhtns.com
обсуждение исходный текст
Ответ на Re: select distinct on varchar - wild performance differences!  (Tom Lane <tgl@sss.pgh.pa.us>)
Список 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@dhtns.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
>

В списке pgsql-performance по дате отправления:

Предыдущее
От: Dave Cramer
Дата:
Сообщение: Re: Performance Tuning Article
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Performance Tuning Article