Received: from maia.hub.org (maia-3.hub.org [200.46.204.243]) by mail.postgresql.org (Postfix) with ESMTP id B68621337BCF for ; Tue, 5 Oct 2010 22:23:56 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.243]) (amavisd-maia, port 10024) with ESMTP id 67774-04 for ; Wed, 6 Oct 2010 01:23:49 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from mail.postnewspapers.com.au (202-89-185-120.static.dsl.amnet.net.au [202.89.185.120]) by mail.postgresql.org (Postfix) with ESMTP id C8CFA1337BC1 for ; Tue, 5 Oct 2010 22:23:48 -0300 (ADT) Received: from localhost (localhost [127.0.0.1]) by mail.postnewspapers.com.au (Postfix) with ESMTP id 11513AFB1B; Wed, 6 Oct 2010 09:23:44 +0800 (WST) X-Virus-Scanned: Debian amavisd-new at postnewspapers.com.au Received: from mail.postnewspapers.com.au ([127.0.0.1]) by localhost (mail.postnewspapers.com.au [127.0.0.1]) (amavisd-new, port 10024) with LMTP id h-7AKmIh4onT; Wed, 6 Oct 2010 09:23:38 +0800 (WST) Received: from [10.1.1.6] (124-148-209-200.dyn.iinet.net.au [124.148.209.200]) (using TLSv1 with cipher DHE-RSA-AES256-SHA (256/256 bits)) (Client CN "Craig Ringer", Issuer "POST Certificate Authority" (verified OK)) by mail.postnewspapers.com.au (Postfix) with ESMTPSA id 7F207AE3A1; Wed, 6 Oct 2010 09:23:37 +0800 (WST) Message-ID: <4CABCF97.1060903@postnewspapers.com.au> Date: Wed, 06 Oct 2010 09:23:35 +0800 From: Craig Ringer User-Agent: Mozilla/5.0 (X11; U; Linux x86_64; en-US; rv:1.9.2.9) Gecko/20100921 Fedora/3.1.4-1.fc14 Thunderbird/3.1.4 MIME-Version: 1.0 To: Merlin Moncure CC: "Sander, Ingo (NSN - DE/Munich)" , pgsql-performance@postgresql.org Subject: Re: Runtime dependency from size of a bytea field References: <9EB22E4572ECF74AAFEAE743C74D26B203A53EE8@DEMUEXC005.nsn-intra.net> In-Reply-To: Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-1.9 tagged_above=-10 required=5 tests=BAYES_00=-1.9 X-Spam-Level: X-Archive-Number: 201010/37 X-Sequence-Number: 40456 On 10/06/2010 12:11 AM, Merlin Moncure wrote: > Probably you are hitting toast threshold and running into compression. > compression you can disable, but toast you cannot (short of > recompiling with higher blocksz). For the OP's reference: http://www.postgresql.org/docs/current/static/storage-toast.html http://www.postgresql.org/docs/current/static/sql-altertable.html While (I think) PLAIN storage could be used, the inability to span rows over blocks means you would't get over 8k anyway. -- Craig Ringer