On Thu, Jun 11, 2009 at 4:24 PM, Kevin Grittner<kevin.gritt...@wicourts.gov> 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 (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
