Re: slow sort - Mailing list pgsql-performance

From Maximilian Tyrtania
Subject Re: slow sort
Date
Msg-id CDA255AF-5FF4-4C8C-8A0D-501D4D340C7E@contactking.de
Whole thread Raw
In response to Re: slow sort  (bricklen <bricklen@gmail.com>)
List pgsql-performance
Thanks, unfortunately it (creating that index) didn't. But I rewrote my query using inline subqueries, which already
helpeda lot. 

Thanks again,

Maximilian Tyrtania
http://www.contactking.de

Am 11.09.2013 um 15:58 schrieb bricklen <bricklen@gmail.com>:

>
> 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?



pgsql-performance by date:

Previous
From: bricklen
Date:
Subject: Re: slow sort
Next
From: Andrew Dunstan
Date:
Subject: Re: slow sort