Re: Indexed views?

Greg Stark <gsstark(at)mit(dot)edu> writes:
> Hm. Just thinking aloud here. But what if there was an option to store the
> visibility information separately from the heap entirely. There would still
> only be one copy of the visibility information and it wouldn't increase
> storage or i/o requirements.

How do you figure that it wouldn't increase I/O? In most scenarios that
would be still another block to read in to find out whether a tuple is
valid. (And that's assuming that you don't need any fancy indexing
scheme to associate tuples with visibility records.)

> But if the table has particularly wide records, then it might be useful to
> avoid having to read in the many blocks of records.

I think the TOAST scheme already gets much of the low-hanging fruit
here. It might be interesting to expose more TOAST control knobs,
though --- for instance make the thresholds settable per-table.

regards, tom lane