| 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: | Whole Thread | Raw Message | 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 |