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@xxxxxxxxx>: > > On Wed, Sep 11, 2013 at 3:36 AM, Maximilian Tyrtania <lists@xxxxxxxxxxxxxx> 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? -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
