It looks like we need a new Column Storage option for MAIN, Uncompressed.
We have these Column Storage options
Plain - inline only, uncompressed
Main - inline until external as last resort, compressible
External - external, uncompressed
Extended - external, compressible
So there is no option for Main, but not compressible...
With reference to code... there seems to be no way to skip step 3
/* ----------* Compress and/or save external until data fits into target length** 1: Inline compress attributes with
attstorage'x', and store very* large attributes with attstorage 'x' or 'e' external immediately* 2: Store
attributeswith attstorage 'x' or 'e' external* 3: Inline compress attributes with attstorage 'm'* 4: Store attributes
withattstorage 'm' external* ----------*/
Not sure what to call this new option? MAINU?
Objections?
--
Simon Riggs http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services