>>>>> "Tom" == Tom Lane <[email protected]> writes:
Tom> The only real solution, of course, is to acquire cross-column Tom> statistics, but I don't see that happening
inthe near Tom> future.
Another approach is a hybrid hashing scheme where we use a hash table
until we run out of memory at which time we start spilling to disk. In
other words, no longer use SortAgg at all ..
Under what circumstances will a SortAgg consumer more IOs than a
hybrid hash strategy ?
--
Pip-pip
Sailesh
http://www.cs.berkeley.edu/~sailesh
