pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  

help / color / mirror / Atom feed

From: Craig Ringer <craig@postnewspapers.com.au>
To: Merlin Moncure <mmoncure@gmail.com>
Cc: Sander, Ingo (NSN - DE/Munich) <ingo.sander@nsn.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: Runtime dependency from size of a bytea field
Date: Wed, 06 Oct 2010 09:23:35 +0800
Message-ID: <4CABCF97.1060903@postnewspapers.com.au> (raw)
In-Reply-To: <AANLkTimFKPtR5oz5DBTkrDqctUwBtAk36EcBOqzt9t5v@mail.gmail.com>
References: <9EB22E4572ECF74AAFEAE743C74D26B203A53EE8@DEMUEXC005.nsn-intra.net>
	<AANLkTimFKPtR5oz5DBTkrDqctUwBtAk36EcBOqzt9t5v@mail.gmail.com>

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

view thread (12+ messages)  latest in thread

Message-ID: <4CABCF97.1060903@postnewspapers.com.au>
Permalink:  ../4CABCF97.1060903@postnewspapers.com.au/
Also on:    postgresql.org/message-id/4CABCF97.1060903@postnewspapers.com.au

copy link · copy postgr.es

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-performance@postgresql.org
  Cc: craig@postnewspapers.com.au, mmoncure@gmail.com, ingo.sander@nsn.com
  Subject: Re: Runtime dependency from size of a bytea field
  In-Reply-To: <4CABCF97.1060903@postnewspapers.com.au>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox