Postgres Pro
Downloads
Home   >   mailing lists

Re: US Census database (Tiger 2004FE) - Mailing list pgsql-hackers

From Mark Woodward
Subject Re: US Census database (Tiger 2004FE)
Date
Msg-id 22673.24.91.171.78.1123165015.squirrel@mail.mohawksoft.com
Whole thread Raw
In response to Re: US Census database (Tiger 2004FE)  (Christopher Kings-Lynne <chriskl@familyhealth.com.au>)
List pgsql-hackers
Tree view 
>> 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.

pgsql-hackers by date:

Previous
From: Christopher Kings-Lynne
Date:
Subject: Re: US Census database (Tiger 2004FE)
Next
From: Tom Lane
Date:
Subject: Re: Solving the OID-collision problem