From: | Maximilian Tyrtania <lists(at)contactking(dot)de> |
---|---|
To: | bricklen <bricklen(at)gmail(dot)com> |
Cc: | "pgsql-performance(at)postgresql(dot)org list" <pgsql-performance(at)postgresql(dot)org> |
Subject: | Re: slow sort |
Date: | 2013-09-11 15:24:48 |
Message-ID: | CDA255AF-5FF4-4C8C-8A0D-501D4D340C7E@contactking.de |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-performance |
Thanks, unfortunately it (creating that index) didn't. But I rewrote my query using inline subqueries, which already helped a lot.
Thanks again,
Maximilian Tyrtania
http://www.contactking.de
Am 11.09.2013 um 15:58 schrieb bricklen <bricklen(at)gmail(dot)com>:
>
> 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?
From | Date | Subject | |
---|---|---|---|
Next Message | Andrew Dunstan | 2013-09-11 15:31:47 | Re: slow sort |
Previous Message | bricklen | 2013-09-11 13:58:21 | Re: slow sort |