On Mon, Oct 26, 2015 at 12:45 PM, David Osborne <david@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