Postgres Pro
Downloads
Home   >   mailing lists

Re: Optimization of unnecessary GROUP BY columns - Mailing list pgsql-general

From Martijn van Oosterhout
Subject Re: Optimization of unnecessary GROUP BY columns
Date
Msg-id 20061226171352.GE8412@svana.org
Whole thread Raw
In response to Optimization of unnecessary GROUP BY columns  (Kevin Murphy <murphy@genome.chop.edu>)
Responses Re: Optimization of unnecessary GROUP BY columns  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
Tree view 
On Tue, Dec 26, 2006 at 12:08:04PM -0500, Kevin Murphy wrote:
> When columns are required in a GROUP BY clause even though some of them
> are fully dependent on others, is there any plan for making it possible
> to do the GROUP BY only on the necessary columns?  The 8.X documentation
> made me curious:

Recent SQL standards require it, so it's likely to be implemented at
some point.

Havn't seen any patches in that direction though...

Have a nice day,
--
Martijn van Oosterhout   <kleptog@svana.org>   http://svana.org/kleptog/
> From each according to his ability. To each according to his ability to litigate.
Attachment

pgsql-general by date:

Previous
From: Kevin Murphy
Date:
Subject: Optimization of unnecessary GROUP BY columns
Next
From: "Melvin Davidson"
Date:
Subject: Functions to obtain group members- PostgreSQL prior to 8.1