| From: | Albe Laurenz <laurenz(dot)albe(at)wien(dot)gv(dot)at> |
|---|---|
| To: | '"Leonardo M(dot) Ramé" *EXTERN*' <l(dot)rame(at)griensu(dot)com>, "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Compression function |
| Date: | 2015-06-16 08:24:29 |
| Message-ID: | A737B7A37273E048B164557ADEF4A58B50F62865@ntex2010a.host.magwien.gv.at |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Xavier 12 | 2015-06-16 08:55:11 | pg_xlog on a hot_stanby slave |
| Previous Message | Leonardo M. Ramé | 2015-06-16 07:45:52 | Compression function |