On Thu, Sep 29, 2011 at 10:54 AM, Jon Nelson <jnelson+pgsql@jamponi.net> wrote:
> On Thu, Sep 29, 2011 at 10:51 AM, David North <dtn@corefiling.co.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).
They are assuming you didn't turn compression off manually and the
objects were big enough to toast. If you truly didn't need access to
the data in the backend, compressing on the client and disabling
compression on the server is probably a good idea.
merlin