Thanks for the help with that, Noah. Indeed the sizes do look like I'd expect them to if I force deflation of the bytea value before inserting it into the EXTENDED column. On Apr 21, 2011, at 2:02 PM, Noah Misch wrote: > On Mon, Apr 11, 2011 at 03:19:23PM -0700, Joel Stevenson wrote: >> create table obj1 ( object bytea ); >> create table obj2 ( object bytea ); >> alter table obj2 alter column object set storage external; >> insert into obj1 ( object ) select object from serialized_content where id = 12345; >> insert into obj2 ( object ) select object from obj1; > > If the value that shows up for insertion is already compressed, EXTERNAL storage > will not decompress it. Change this line to > > insert into obj2 ( object ) select object || '' from obj1; > > to observe the effect you seek. > > Given the purpose of EXTERNAL storage, this might qualify as a bug. -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
