Re: "Truncated" tuples for tuple hash tables

On Mon, 2006-06-26 at 16:43 -0400, Tom Lane wrote:
> I wrote:
> > There isn't any benefit except where we collect lots of tuples, which is
> > to say tuplesort/tuplestore/tuplehashtable. In other places in the
> > executor, there's basically only one transient tuple in existence per
> > plan node; jumping through hoops to save 16 bytes per plan node is just
> > silly. (What's more, as of 8.1 most of those tuples will be in "virtual
> > tuple" format anyway, and so the optimization wouldn't make any
> > difference at all...)
>
> After further study of the code, here's my hit-list of places that could
> make worthwhile use of MinimalTuples:
>
> tuplesort.c (in-memory, on-disk case done already)
> tuplestore.c (in-memory and on-disk)
> TupleHashTable (execGrouping.c --- used by nodeAgg and nodeSubplan)
> hash joins (in-memory hash table and tuple "batch" files)

Thats the list I thought you meant.

> analyze.c (tuples collected in-memory for stats analysis)

Do we save enough there for us to care?

Will that allow us to increase the sample size for larger tables?

--
Simon Riggs
EnterpriseDB http://www.enterprisedb.com