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

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Peter J(dot) Holzer" <hjp-pgsql(at)hjp(dot)at>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: Query that took a lot of time in Postgresql when not using trim in order by
Date: 2015-11-29 17:58:36
Message-ID: 6979.1448819916@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

"Peter J. Holzer" <hjp-pgsql(at)hjp(dot)at> 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

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Glyn Astill 2015-11-30 14:03:21 Re: Index scan cost calculation
Previous Message Peter J. Holzer 2015-11-29 13:23:23 Re: Query that took a lot of time in Postgresql when not using trim in order by