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(at)lusis(dot)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