On Thu, Sep 29, 2011 at 10:54 AM, Jon Nelson <[email protected]> wrote: > On Thu, Sep 29, 2011 at 10:51 AM, David North <[email protected]> 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 ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
