Horton

Re: US Census database (Tiger 2004FE)

Mark Woodward <pgsql@mohawksoft.com>

View thread
From: "Mark Woodward" <pgsql@mohawksoft.com>
To: "Christopher Kings-Lynne" <chriskl@familyhealth.com.au>
Cc: "Stephen Frost" <sfrost@snowman.net>, pgsql-hackers@postgresql.org
Date: 2005-08-04T14:16:55Z
Lists: pgsql-hackers 
>> It's been running for about an hour now, and it is up to 3.3G.
>>
>> pg_dump tiger | gzip > tiger.pgz
>
> | bzip2 > tiger.sql.bz2 :)
>

I find bzip2 FAR SLOWER than the gain in compression.