Home > mailing lists

Re: slow sort - Mailing list pgsql-performance

From	bricklen
Subject	Re: slow sort
Date	September 11, 2013 16:58:26
Msg-id	CAGrpgQ-QmjWj1hirygwR9O8vOr48jUC3BBP_1pkr1gyHmD0Wpw@mail.gmail.com Whole thread Raw
In response to	slow sort (Maximilian Tyrtania <lists@contactking.de>)
Responses	Re: slow sort (Maximilian Tyrtania <lists@contactking.de>)
List	pgsql-performance

On Wed, Sep 11, 2013 at 3:36 AM, Maximilian Tyrtania <lists@contactking.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?

From: Merlin Moncure
Date: 11 September 2013, 15:43:45
Subject: Re: Intermittent hangs with 9.2

From: Maximilian Tyrtania
Date: 11 September 2013, 18:24:58
Subject: Re: slow sort