Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-performance by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group