Re: bytea columns and large values

From: Jon Nelson <jnelson+pgsql(at)jamponi(dot)net>
To: David North <dtn(at)corefiling(dot)co(dot)uk>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: bytea columns and large values
Date: 2011-09-29 15:54:52
Message-ID: CAKuK5J2zDHrZrcEieA9Df9VYSufqGVrQR8iyqgh=dQwdDU38nA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Thu, Sep 29, 2011 at 10:51 AM, David North <dtn(at)corefiling(dot)co(dot)uk> wrote:

> I'll also apply GZip to keep the amount of data in any given bytea/lob as
> small as possible.

Aren't bytea fields compressed by postgresql anyway (when EXTENDED or
MAIN is used) (by default).

http://www.postgresql.org/docs/8.4/static/storage-toast.html

--
Jon

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message salah jubeh 2011-09-29 16:04:05 create a dynamic function
Previous Message Simon Riggs 2011-09-29 15:54:20 Re: pg_stat_replication data in standy servers