| From: | "David Hinkle" <hinkle(at)cipafilter(dot)com> |
|---|---|
| To: | <pgsql-performance(at)postgresql(dot)org> |
| Subject: | Help with TOAST Compression |
| Date: | 2007-04-17 21:13:36 |
| Message-ID: | 41CAB934FDE0DA4392781E79BDF1894710A062@cipapdc.cipafilter.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
I have a table where I store email, the bodies are mostly kept in a
toast table. The toast table is 940 Meg in size. The whole database
is about 1.2 Gig in size. When I back the database up using pg_dump in
custom output mode, I pipe the output into gzip. My backups are only
about 600 meg in size. From this, I assume the that toe toast table
isn't getting compressed.
I am keeping the bodies in a column of type "bytea".
Is there any way I can tell for sure if the messages from this column
are being stored compressed? I know I can set the compression settings
using the "ALTER TABLE ALTER SET STORAGE" syntax, but is there a way I
can see what this value is currently set to?
David
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Craig A. James | 2007-04-18 03:57:01 | Re: Basic Q on superfluous primary keys |
| Previous Message | cluster | 2007-04-17 20:53:51 | Re: FK triggers misused? |