How long does gzip take to compress this backup? On Wed, 2006-06-14 at 15:59, John Vincent wrote: > Okay I did another test dumping using the uncompressed backup on the > system unloaded and the time dropped down to 8m for the backup. > There's still the size issue to contend with but as I said, I've got a > fair bit of space left on the SAN to work with. > > On 6/14/06, John Vincent <pgsql-performance@xxxxxxxxx> wrote: > Well I did a test to answer my own question: > > -rw-r--r-- 1 postgres postgres 167M Jun 14 01:43 > claDW_PGSQL-20060613170001.bak > -rw-r--r-- 1 root root 2.4G Jun 14 14:45 > claDW_PGSQL.test.bak > > the claDW_PGSQL database is a subset of the data in the main > schema that I'm dealing with. > > I did several tests using -Fc -Z0 and a straight pg_dump with > no format option. > > The file size is about 1300% larger and takes just as long to > dump even for that small database. > > Interestingly enough gzip compresses about 1M smaller with no > gzip options. > > I don't know that the uncompressed is really helping much. I'm > going to run another query when there's no other users on the > system and see how it goes. > > > > -- > John E. Vincent
