Re: Group-count estimation statistics - Mailing list pgsql-hackers

From Kris Jurka
Subject Re: Group-count estimation statistics
Date
Msg-id Pine.BSO.4.56.0501281628001.23832@leary.csoft.net
Whole thread Raw
In response to Re: Group-count estimation statistics  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: Group-count estimation statistics
List pgsql-hackers

On Fri, 28 Jan 2005, Tom Lane wrote:

> you don't GROUP BY unique combinations of columns over huge
> tables --- or at least, you shouldn't expect great performance if you do.

The proposed change biases towards a hash plan which has no provision for
spilling to disk.  Slow is one thing, but excessive memory usage and
possibly failing is another thing.

Kris Jurka


pgsql-hackers by date:

Previous
From: Bruno Wolff III
Date:
Subject: Re: Allow GRANT/REVOKE permissions to be applied to all schema objects with one command
Next
From: "Merlin Moncure"
Date:
Subject: Re: Allow GRANT/REVOKE permissions to be applied to all schema objects with one command