Postgres Pro
Downloads
Home   >   mailing lists

Re: unnecessary sort in the execution plan when doing group by - Mailing list pgsql-performance

From Simon Riggs
Subject Re: unnecessary sort in the execution plan when doing group by
Date
Msg-id CA+U5nMJdUtyDcF9Z_k1x3VfEM+xf9vRTXdXWsU2e879DxZEsGQ@mail.gmail.com
Whole thread Raw
In response to unnecessary sort in the execution plan when doing group by  ("Huang, Suya" <Suya.Huang@au.experian.com>)
List pgsql-performance
Tree view 
On 28 October 2014 06:26, Huang, Suya <Suya.Huang@au.experian.com> wrote:

>    Memory wanted: 3565580K bytes

This means "increase work_mem to this value".

--
 Simon Riggs                   http://www.2ndQuadrant.com/
 PostgreSQL Development, 24x7 Support, Training & Services

pgsql-performance by date:

Previous
From: Stuart Bishop
Date:
Subject: Re: Replication Lag Causes
Next
From: jmcdonagh
Date:
Subject: Re: Incredibly slow restore times after 9.0>9.2 upgrade