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