View Single Post

   
  #2 (permalink)  
Old 04-18-2008, 11:56 AM
Tom Lane
 
Posts: n/a
Default Re: select distinct on varchar - wild performance differences!

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

Reply With Quote