Re: Optimization of unnecessary GROUP BY columns

From: Martijn van Oosterhout <kleptog(at)svana(dot)org>
To: Kevin Murphy <murphy(at)genome(dot)chop(dot)edu>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Optimization of unnecessary GROUP BY columns
Date: 2006-12-26 17:13:52
Message-ID: 20061226171352.GE8412@svana.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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(at)svana(dot)org> http://svana.org/kleptog/
> From each according to his ability. To each according to his ability to litigate.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Melvin Davidson 2006-12-26 17:58:28 Functions to obtain group members- PostgreSQL prior to 8.1
Previous Message Kevin Murphy 2006-12-26 17:08:04 Optimization of unnecessary GROUP BY columns