Re: slow sort

From: bricklen <bricklen(at)gmail(dot)com>
To: Maximilian Tyrtania <lists(at)contactking(dot)de>
Cc: "pgsql-performance(at)postgresql(dot)org list" <pgsql-performance(at)postgresql(dot)org>
Subject: Re: slow sort
Date: 2013-09-11 13:58:21
Message-ID: CAGrpgQ-QmjWj1hirygwR9O8vOr48jUC3BBP_1pkr1gyHmD0Wpw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

On Wed, Sep 11, 2013 at 3:36 AM, Maximilian Tyrtania
<lists(at)contactking(dot)de>wrote:

>
> JOIN emailsendings es ON et. ID = es.emailtemplate_id
>
ORDER BY
> es.sentonat desc
>

Perhaps on an index on (es.emailtemplate_id, es.sentonat desc) would help?

In response to

  • slow sort at 2013-09-11 10:36:42 from Maximilian Tyrtania

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Maximilian Tyrtania 2013-09-11 15:24:48 Re: slow sort
Previous Message Merlin Moncure 2013-09-11 12:43:35 Re: Intermittent hangs with 9.2