Re: Performance of pg_dump on PGSQL 8.0

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@lusis.org> 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