On Mon, 2010-05-03 at 23:36 -0400, Jan Wieck wrote:

Suppose we had something similar to the NULL value bitmap, specifying
plain or compressed values (not TOAST references), that are moved to a
shadow tuple inside the toast table. Suppose further we had some
statistics about how often attributes appear in a qualification (i.e.
end up in a scan key or scan filter or other parts of the qual
expression list). Not sure, maybe we even want to know how often or
seldom an attribute is heap_getattr()'d at all. Those don't need to be
accurate counts. Small random samples will probably do. ANALYZE could
evaluate those statistics and adjust the "shadow" storage settings per
attribute accordingly.

I can imagine many applications, where this would shrink the main
tuples to almost nothing at all.
Automatic vertical partitioning. Like it.

TODO item for further detailed research.

Simon Riggs www.2ndQuadrant.com

Search Discussions

Discussion Posts


Related Discussions

Discussion Navigation
viewthread | post
posts ‹ prev | 5 of 5 | next ›
Discussion Overview
grouppgsql-hackers @
postedMay 2, '10 at 12:46p
activeMay 4, '10 at 8:14a



site design / logo © 2021 Grokbase