Re: [PERFORM] Help with TOAST Compression

On Tue, Apr 17, 2007 at 04:13:36PM -0500, David Hinkle wrote: 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

[PERFORM] Help with TOAST Compression

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