On Thu, Sep 29, 2011 at 10:54 AM, Jon Nelson <jnelson+pgsql@xxxxxxxxxxx> wrote: > On Thu, Sep 29, 2011 at 10:51 AM, David North <dtn@xxxxxxxxxxxxxxxx> 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 -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
