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? > > Different locale setting? strcoll() can be horribly slow in some > locales ... > > regards, tom lane > > ---------------------------(end of broadcast)--------------------------- > TIP 8: explain analyze is your friend > ---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives? http://archives.postgresql.org