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 <[email protected]>: > > On Wed, Sep 11, 2013 at 3:36 AM, Maximilian Tyrtania <[email protected]> > 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 ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
