From: Antonin Houska <ah@cybertec.at>
To: legrand legrand <legrand_legrand@hotmail.com>
cc: pgsql-hackers@postgresql.org
Subject: Re: WIP: Aggregation push-down
In-reply-to: <1580507988788-0.post@n3.nabble.com>
References: 
 <CAN_9JTy95UMjOVDSc-4MBrA6Fc1hX2vh=t2RMHp=yGyAV=-Xsw@mail.gmail.com>
 <1897.1562680064@spoje.net>
 <CAN_9JTzC1K-Gc3p5GD=dQeJD8k_Z5996B0rEYjVGx+pXPq8JPw@mail.gmail.com>
 <13971.1562920911@spoje.net>
 <CAN_9JTzAsBwv5zr4SRVO35OtMWQBXSLcUuY65NQ0ZtFCTOrMMA@mail.gmail.com>
 <19857.1563374392@localhost> <20190904202339.GA13644@alvherre.pgsql>
 <7087.1567663858@localhost> <20200111011124.efacqhdsptc36pm2@development>
 <72558.1579188350@antos> <1580507988788-0.post@n3.nabble.com>
Comments: In-reply-to legrand legrand <legrand_legrand@hotmail.com>
   message dated "Fri, 31 Jan 2020 14:59:48 -0700."
MIME-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
Content-ID: <68526.1580715963.1@antos>
Date: Mon, 03 Feb 2020 08:46:03 +0100
Message-ID: <68527.1580715963@antos>
Precedence: bulk

legrand legrand <legrand_legrand@hotmail.com> wrote:

> set enable_agg_pushdown to true;
> isn't displayed in EXPLAIN (SETTINGS) syntax.
> 
> 
> The following modification seems to fix that: 
> 
> src/backend/utils/misc/guc.c
>  
>  		{"enable_agg_pushdown", PGC_USERSET, QUERY_TUNING_METHOD,
> 			gettext_noop("Enables aggregation push-down."),
> 			NULL,
> 			GUC_EXPLAIN   <<<<--- line Added --->>>>
> 		},
> 		&enable_agg_pushdown,
> 		false,
> 		NULL, NULL, NULL
> 	},

Thanks. I'll include this change in the next version.

-- 
Antonin Houska
Web: https://www.cybertec-postgresql.com