On Mon, Oct 26, 2015 at 12:45 PM, David Osborne <da...@qcode.co.uk> wrote: > Physical memory is 61GB at the moment. > > work_mem is 1,249,104kB
I'm not sure if this query is a candidate because of the function, but you can try progressively cranking work_mem and running explain to see what it'd take to get a hashaggregate plan. merlin -- Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance