Re: [PERFORM] unnecessary sort in the execution plan when doing group by

2014-11-04 Thread Simon Riggs
On 28 October 2014 06:26, Huang, Suya 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 -- Sent via pgsql-performance mailing list (

Re: [PERFORM] unnecessary sort in the execution plan when doing group by

2014-10-28 Thread Huang, Suya
bject: Re: [PERFORM] unnecessary sort in the execution plan when doing group by On Tue, Oct 28, 2014 at 7:26 PM, Huang, Suya mailto:suya.hu...@au.experian.com>> wrote: Hi, This is the Greenplum database 4.3.1.0. Likely this is the wrong place to ask for help. The plan output that you'

Re: [PERFORM] unnecessary sort in the execution plan when doing group by

2014-10-28 Thread David Rowley
On Tue, Oct 28, 2014 at 7:26 PM, Huang, Suya wrote: > Hi, > > > > This is the Greenplum database 4.3.1.0. > > Likely this is the wrong place to ask for help. The plan output that you've pasted below looks very different to PostgreSQL's EXPLAIN output.

[PERFORM] unnecessary sort in the execution plan when doing group by

2014-10-27 Thread Huang, Suya
Hi, This is the Greenplum database 4.3.1.0. Tables : dev=# \d+ visits_weekly_new_3 Append-Only Columnar Table "uk.visits_weekly_new_3" Column | Type | Modifiers | Storage | Compression Type | Compression Level | Block Size | Description --++---+--