Re: Fwd: [GENERAL] 4B row limit for CLOB tables

On 2/3/15 10:01 AM, José Luis Tallón wrote:<br /><br /><blockquote cite="mid:54D0E2B1.3030900@adv-solutions.net"
type="cite">Hmmm....alter column set storage external / set storage extended ? <br /><br /> From <a
class="moz-txt-link-freetext"
href="http://www.postgresql.org/docs/9.4/static/sql-altertable.html">http://www.postgresql.org/docs/9.4/static/sql-altertable.html</a>
:<br />     ALTER [ COLUMN ] column_name SET STORAGE { PLAIN | EXTERNAL | EXTENDED | MAIN } <br /><br />     This would
dowhat you described, right? <br /></blockquote><br /> EXTENDED is the default for most TOAST-able types and is still
subjectto <tt class="SYMBOL">TOAST_TUPLE_THRESHOLD which is normally 2K.  EXTERNAL is the same but with no
compression.<br/><br /> See: <a class="moz-txt-link-freetext"
href="http://www.postgresql.org/docs/9.4/static/storage-toast.html">http://www.postgresql.org/docs/9.4/static/storage-toast.html</a><br
/><br/></tt> <pre class="moz-signature" cols="72">--  
- David Steele
<a class="moz-txt-link-abbreviated" href="mailto:david@pgmasters.net">david@pgmasters.net</a></pre>