On Thu, Jun 11, 2009 at 4:24 PM, Kevin Grittner<[email protected]> wrote: > > I thought that's the behavior of EXTENDED. The fine manual says "MAIN > allows compression but not out-of-line storage. (Actually, out-of-line > storage will still be performed for such columns, but only as a last > resort when there is no other way to make the row small enough.)" > > If that doesn't mean that it will only use out-of-line storage when > the row doesn't fit in the page, then the manual could use a fix.
I agree that "small enough" could be more precise. As it happens tuptoaster.c only has one definition of "small enough" which is whether the record is smaller than TOAST_TUPLE_THRESHOLD. I wonder actually if this case shouldn't use the block size, not the target size. That seems like it would be a lot more useful. -- Gregory Stark http://mit.edu/~gsstark/resume.pdf -- Sent via pgsql-hackers mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
