Re: [PERFORM] slow sort

that the query screams for a CTE. Thanks for the eye opener. Maximilian Tyrtania http://www.contactking.de -- Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance

[PERFORM] slow sort

1203.783 ms 20.7 % Sort1 3304.075 ms 56.9 % , so the sort appears to be the problem. Any pointers would be highly appreciated. Maximilian Tyrtania http://www.contactking.de -- Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) To make changes to your

Re: [PERFORM] slow sort

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 brick...@gmail.com: On Wed, Sep 11, 2013 at 3:36 AM