On Mon, Oct 26, 2015 at 12:45 PM, David Osborne 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 hashagg
Physical memory is 61GB at the moment.
work_mem is 1,249,104kB
>>
> What's physical memory and setting of work_mem?
>
> merlin
>
--
David Osborne
Qcode Software Limited
http://www.qcode.co.uk
T: +44 (0)1463 896484
On Fri, Oct 23, 2015 at 12:45 PM, Jamie Koceniak
wrote:
> Hi,
>
> We just had the performance problem again today.
> Here is some of the top output. Unfortunately, we don't have perf top
> installed.
>
> top - 16:22:16 up 29 days, 13:00, 2 users, load average: 164.63, 158.62,
> 148.52
> Tasks:
