Re: [PERFORM] Query that took a lot of time in Postgresql when not using trim in order by

"Peter J. Holzer" writes: > Seems plausible. Also I'm wondering what CPU this is: 36 seconds for an > in-memory sort of 900k rows seems slow to me. I'm wondering if it's textual data in some locale whose strcoll() behavior is exceptionally slow. regards, tom lane -- Se

Re: [PERFORM] Query that took a lot of time in Postgresql when not using trim in order by

On 2015-11-25 19:35:15 +0300, Evgeniy Shishkin wrote: > Fast: > > Sort (cost=193101.41..195369.80 rows=907357 width=129) (actual > time=3828.176..3831.261 rows=43615 loops=1) >Output: dim_cliente.tipocliente, dim_cliente.a1_ibge, dim_cliente.a1_cod, > dim_cliente.a1_nome, dim_vendedor.a3_n