[PERFORM] select distinct on varchar -- wild performance differences!

Hey, all. I've bounced this around in #postgres for an hour or so, and it was suggested that I post it here as well. Hopefully someone can help me out. I have three machines. All have 512MB of ram. Machine A is a 2.0ghz celeron, running debian, pg verison 7.4.6. Machine B is a 1.8ghz celeron

Re: [PERFORM] select distinct on varchar - wild performance differences!

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 <[EMAIL PROTECTED]> writes: > > Anyone have any ideas as to what may be up with machine B

Re: [PERFORM] select distinct on varchar - wild performance differences!

Elliott Bennett <[EMAIL PROTECTED]> 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)--

[PERFORM] select distinct on varchar - wild performance differences!

Hey, all. I've bounced this around in #postgres for an hour or so, and it was suggested that I post it here as well. Hopefully someone can help me out. I have three machines. All have 512MB of ram. Machine A is a 2.0ghz celeron, running debian, pg verison 7.4.6. Machine B is a 1.8ghz celeron, r