Re: GroupAggregate and Integer Arrays - Mailing list pgsql-performance

From Merlin Moncure
Subject Re: GroupAggregate and Integer Arrays
Date
Msg-id CAHyXU0xfum4bhhPRNwU4XfG3=MgZM5JB4B42gnksRa1JW7uh5A@mail.gmail.com
Whole thread Raw
In response to Re: GroupAggregate and Integer Arrays  (David Osborne <david@qcode.co.uk>)
List pgsql-performance
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


pgsql-performance by date:

Previous
From: David Osborne
Date:
Subject: Re: GroupAggregate and Integer Arrays
Next
From: Bertrand Paquet
Date:
Subject: Query planner wants to use seq scan