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:
>> crea
On Apr 12, 2011, at 10:33 AM, Bill Moran wrote:
> In response to Joel Stevenson :
>
>> select pg_total_relation_size('obj1') as o1, pg_total_relation_size( (select
>> reltoastrelid from pg_class where relname = 'obj1' ) ) as otoast1,
>> pg_total_relation_size('obj2') as o2, pg_total_relation_s
In response to Joel Stevenson :
> Hi all,
>
> I'm trying to do some comparisons between the EXTERNAL and the EXTENDED
> storage methods on a bytea column and from the outside the setting doesn't
> appear to affect the value stored on initial insert, but perhaps I'm looking
> at the wrong numbe
Hi all,
I'm trying to do some comparisons between the EXTERNAL and the EXTENDED storage
methods on a bytea column and from the outside the setting doesn't appear to
affect the value stored on initial insert, but perhaps I'm looking at the wrong
numbers. If I create two new tables with a single