Jeff Janes writes:
> On Thu, Jul 18, 2013 at 8:04 PM, Tom Lane wrote:
>> DISTINCT (and also ORDER BY) properties of aggregates are implemented
>> at runtime; the planner doesn't really do anything about them, except
>> suppress the choice it might otherwise make of using hashed aggregation.
> Co
On Thu, Jul 18, 2013 at 8:04 PM, Tom Lane wrote:
> Jeff Janes writes:
>> AGG_PLAIN sometimes does sorts, but it thinks they are free. Also, under
>> explain analyze it does not explicitly report whether the sort was external
>> or not, nor report the disk or memory usage, the way other sorts do.
On Fri, Jul 19, 2013 at 8:34 AM, Tom Lane wrote:
> Jeff Janes writes:
> > AGG_PLAIN sometimes does sorts, but it thinks they are free. Also, under
> > explain analyze it does not explicitly report whether the sort was
> external
> > or not, nor report the disk or memory usage, the way other sor
Jeff Janes writes:
> AGG_PLAIN sometimes does sorts, but it thinks they are free. Also, under
> explain analyze it does not explicitly report whether the sort was external
> or not, nor report the disk or memory usage, the way other sorts do. I
> don't know if those two things are related or not
AGG_PLAIN sometimes does sorts, but it thinks they are free. Also, under
explain analyze it does not explicitly report whether the sort was external
or not, nor report the disk or memory usage, the way other sorts do. I
don't know if those two things are related or not.
This behavior seems to be