Re: Compression function - Mailing list pgsql-general

From Albe Laurenz
Subject Re: Compression function
Date
Msg-id A737B7A37273E048B164557ADEF4A58B50F62865@ntex2010a.host.magwien.gv.at
Whole thread Raw
In response to Compression function  ("Leonardo M. Ramé" <l.rame@griensu.com>)
List pgsql-general
Leonardo M. Ramé wrote:
> Hi, does anyone know if there's a compression function to let me store
> in gzipped/deflate format TEXT or Bytea fields.
> 
> Please correct me if I'm wrong, but I also wonder if this function is
> really needed since I've read large objects are stored with TOAST, hence
> compression is already there.

Right, TOAST does that.

See http://www.postgresql.org/docs/9.4/static/storage-toast.html
You can control the storage attributes per column.

Yours,
Laurenz Albe

pgsql-general by date:

Previous
From: "Leonardo M. Ramé"
Date:
Subject: Compression function
Next
From: Xavier 12
Date:
Subject: pg_xlog on a hot_stanby slave