Hi, I thougth I have disabled compressing by setting alter command? Or is there another command? BR Ingo -----Original Message----- From: ext Merlin Moncure [mailto:mmoncure@xxxxxxxxx] Sent: Wednesday, October 06, 2010 2:51 PM To: Sander, Ingo (NSN - DE/Munich) Cc: ext Craig Ringer; pgsql-performance@xxxxxxxxxxxxxx Subject: Re: Runtime dependency from size of a bytea field On Wed, Oct 6, 2010 at 1:39 AM, Sander, Ingo (NSN - DE/Munich) <ingo.sander@xxxxxxx> wrote: > Changing of the storage method ( alter table bytea_demo Alter part1 Set > storage EXTERNAL) > or the increasing of the BLOCK_SIZE (new compilation of the code with > --with-blocksize=32) change the behaviour. yeah -- however changing block size is major surgery and is going to have other effects (some of them negative) besides raising toast threshold. I would start with disabling compression and see where you stood on performance terms. merlin -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
